SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(829,1628,3195,514,515,1450,3197,1831,3348,518,1449,830,2296,3200,531,2297,3199,827,516,2204,3196,532,828,826,517,3356,3357,522,1543,2287,2275,2285,2281,2272,2274,3201,2210,3203,519,1447,2295,2293,1827,3314,831,3206,3208,535,3082,538,2278,886,541,2289,542,3367,1445,2471,525,1622,1446,524,1444,543,3370,150,3081,546,547,550,3084,549,552,3062,3063,553,1620,2269,1617,1191,556,557,1140,523,2270,1185,3068,2214,3091,561,2215,2268,1619,569,571,3093,3096,3095,573,2264,2262,578,3071,3070,2301,528,579,3086,581,1138,582,583,1186,2288,2283,2059,2060,2271,2273,1612,584,1611,2282,3085,2286,2284,2280,2510,3061,3065,3066,3089,3421,3420,1609,1610,3419,1132,3092,3087,3417,2061,883,3416,1182,585,3415,871,3094,2261,2276,1615,1192,587,3067,669,2304,2303,675,2972,3064,2302,2292,589,588,526,2290,3088,3414,2266,1036,1731,1732,3098,3102,1529,2259,2256,2405,1129,1128,1127,3107,3099,3103,2260,3109,3108,3104,1196,3413,592,3106,593,2255,594,3111,676,3069,1125,677,529,530,1122,1637,2416,3101,2053,2048,2254,2252,3408,3110,2249,1644,2251,595,2250,1139,1119,3412,3112,596,3113,598,3097,2050,2054,599,2253,3115,600,629,628,626,627,630,679,3073,3075,3076,680,3072,601,623,622,621,620,1117,2403,3100,2051,2055,602,2049,1116,3411,1115,3410,3409,1631,3407,3406,3114,3116,2056,1195,1650,1137,2246,3117,3074,149,3077,619,2298,618,3078,2299,3080,3079,614,616,613,682,2057,2058,603,2052,3404,3403,604,3118,3119,3402,3401,3400,610,1135,3399,3398,2247,3397,3396,686,2294,607,3395,645,1621,1618,562,574,2267,2263,2258,2257,1525,3058,1142,3057,2418,841,842,1608,1143,1144,843,1730,844,2411,821,1607,822,2419,1602,2421,845,2420,846,824,823,847,1145,1606,2412,1147,1604,2423,2424,849,2279,851,2402,852,2404,2415,855,854,856,2422,1157,857,1159,2265,839,840,1150,1151,1149,1152,2406,2390,2407,859,860,2410,1161,2399,1162,1164,862,2393,1166,863,864,1168,2391,1169,1167,1170,865,2392,866,867,868,2387,3051,869,1190,1189,3499,1605,2408,1146,2413,1603,1524,1156,2409,1155,1154,1158,873,874,2417,2414,2398,2557,1153,1165,1163,1160,875,2400,2401,876,2216,1171,697,2397,877,3262,3257,702,701,3275,3274,699,3272,3273,3277,3276,3345,2446,2822,698,696,2830,3340,695,3056,3055,963,1733,3059,705), 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 (149,150,514,515,516,517,518,519,522,523,524,525,526,528,529,530,531,532,535,538,541,542,543,546,547,549,550,552,553,556,557,561,569,571,573,578,579,581,582,583,584,585,587,588,589,592,593,594,595,596,598,599,600,601,602,603,604,607,610,613,614,616,618,619,620,621,622,623,626,627,628,629,630,645,669,675,676,677,679,680,682,686,826,827,828,829,830,831,871,883,886,1036,1115,1116,1117,1119,1122,1125,1127,1128,1129,1132,1135,1137,1138,1139,1140,1182,1185,1186,1191,1192,1195,1196,1444,1445,1446,1447,1449,1450,1529,1543,1609,1610,1611,1612,1615,1617,1619,1620,1622,1628,1631,1637,1644,1650,1731,1732,1827,1831,2048,2049,2050,2051,2052,2053,2054,2055,2056,2057,2058,2059,2060,2061,2204,2210,2214,2215,2246,2247,2249,2250,2251,2252,2253,2254,2255,2256,2259,2260,2261,2262,2264,2266,2268,2269,2270,2271,2272,2273,2274,2275,2276,2278,2280,2281,2282,2283,2284,2285,2286,2287,2288,2289,2290,2292,2293,2294,2295,2296,2297,2298,2299,2301,2302,2303,2304,2403,2405,2416,2471,2510,2972,3061,3062,3063,3064,3065,3066,3067,3068,3069,3070,3071,3072,3073,3074,3075,3076,3077,3078,3079,3080,3081,3082,3084,3085,3086,3087,3088,3089,3091,3092,3093,3094,3095,3096,3097,3098,3099,3100,3101,3102,3103,3104,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3195,3196,3197,3199,3200,3201,3203,3206,3208,3257,3262,3272,3273,3274,3275,3276,3277,3314,3348,3356,3357,3367,3370,3395,3396,3397,3398,3399,3400,3401,3402,3403,3404,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3419,3420,3421,697,821,822,823,824,839,840,841,842,843,844,845,846,847,849,851,852,854,855,856,857,859,860,862,863,864,865,866,867,868,869,873,874,875,876,877,963,1142,1143,1144,1145,1146,1147,1149,1150,1151,1152,1153,1154,1155,1156,1157,1158,1159,1160,1161,1162,1163,1164,1165,1166,1167,1168,1169,1170,1171,1189,1190,1524,1525,1602,1603,1604,1605,1606,1607,1608,1730,1733,2216,2265,2279,2387,2390,2391,2392,2393,2397,2398,2399,2400,2401,2402,2404,2406,2407,2408,2409,2410,2411,2412,2413,2414,2415,2417,2418,2419,2420,2421,2422,2423,2424,2557,3499,705,3051,3055,3056,3057,3058,3059,562,574,1618,1621,2257,2258,2263,2267,695,696,698,699,701,702,2446,2822,2830,3340,3345) 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