SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2949,3250,3279,3281,3282,3285,3286,3287,3288,3289,3292,3293,3297,3298,3299,3301,3302,3304,3306,3308,3309,3314,3315,3317,3318,3321,3322,3324,3325,3326,3327,3328,3329,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3385,3533,3560,3563,3566,3567,3568,3570,3571,3572,3581,3582,3583,3584,3586,3587,3590,3593,3594,3596,3601,3604,3607,3731,3816,3817,3943,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4181,4182,4184), 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 (2448,2449,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2462,2466,2467,2469,2470,2471,2472,2473,2475,2478,2480,2482,2485,2949,3250,3279,3281,3282,3285,3286,3287,3288,3289,3292,3293,3297,3298,3299,3301,3302,3304,3306,3308,3309,3314,3315,3317,3318,3321,3322,3324,3325,3326,3327,3328,3329,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3385,3533,3560,3563,3566,3567,3568,3570,3571,3572,3581,3582,3583,3584,3586,3587,3590,3593,3594,3596,3601,3604,3607,3731,3943,3816,3817,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4181,4182,4184) 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