SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(828,2296,532,2295,542,4083,553,3606,2290,3802,3801,3401,4088,4085,4076,4140,421,2098,3348,531,3560,2204,517,3314,543,526,1449,530,514,515,1450,518,830,2297,827,516,826,420,1448,3357,522,3363,520,521,519,1447,2293,3315,831,281,3367,1445,525,1622,1446,524,1444,3370,556,557,1140,523,3604,528,529,3816,1122,3817,686,416), 1, 0)) as flag FROM zen_products_attributes p2a  JOIN zen_products_options po ON p2a.options_id = po.products_options_id AND po.language_id=2 JOIN zen_products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=2 WHERE p2a.products_id IN (281,416,420,421,514,515,516,517,518,519,520,521,522,523,524,525,526,528,529,530,531,532,542,543,553,556,557,686,826,827,828,830,831,1122,1140,1444,1445,1446,1447,1448,1449,1450,1622,2098,2204,2290,2293,2295,2296,2297,3314,3315,3348,3357,3363,3367,3370,3401,3560,3604,3606,3801,3802,3816,3817,4076,4083,4085,4088,4140) AND p2a.options_id IN (8,10) AND p2a.options_id NOT IN (4,5,6,7,2,3,1) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_sort_order, pov.products_options_values_sort_order