SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(4199,4184,4182,4181,4174,4173,4172,4171,4167,4166,4164,4163,4162,4161,4160,4159,4156,4155,4154,4153,4152,4151,4150,4149,4148,4146,4145,4144,4142,4140,4138,4137,4136,4088,4087,4086,4085,4083,4082,4081,4080,4079,4078,4077,4076,4075,4074,4073,4072,4071,4070,4068,4067,4066,4065,4064,4063,4062,4061,4060,4059,4058,4057,4056,4055,4054,3997,3993,3991,3989,3986,3982,3968,3964,3946,3943,3941,3935,3934,3933,3932,3931,3930,3927,3926,3922,3917,3916,3911,3909,3908,3907,3905,3904,3903,3901,3900,3899,3898,3897,3895,3893,3892,3891,3890,3886,3884,3882,3874,3854,3851,3850,3844,3836,3834,3831,3823,3820,3817,3816,3803,3802,3801,3800,3799,3798,3787,3772,3768,3766,3763,3762,3761,3759,3757,3753,3745,3740,3739,3731,3730,3729,3727,3726,3724,3723,3722,3719,3717,3711,3708,3700,3695,3694,3692,3687,3683,3680,3676,3675,3674,3673,3672,3667,3665,3608,3607,3606,3604,3601,3596,3595,3594,3593,3590,3589,3588,3587,3586,3585,3584,3583,3582,3581,3575,3574,3572,3571,3570,3569,3568,3567,3566,3563,3560,3536,3533,3532,3462,3421,3420,3419,3417,3416,3415,3414,3413,3412,3411,3410,3409,3408,3407,3406,3404,3403,3402,3401,3400,3399,3398,3397,3395,3385,3384,3381,3380,3379,3378,3372,3370,3367,3366,3363,3357,3349,3348,3347,3339,3338,3337,3334,3332,3330,3329,3328,3327,3326,3325,3324,3323,3322,3321,3320,3318,3317,3315,3314,3309,3308,3307,3306,3305,3304,3303,3302,3301,3300,3299,3298,3297,3296,3295,3294,3293,3292,3291,3290,3289,3288,3287,3286,3285,3283,3282,3281,3279,3250,3242,3119,3118,3117,3116,3115,3114,3113,3112,3111,3110,3109,3108,3107,3106,3104,3103,3102,3101,3100,3098,3097,3096,3095,3094,3093,3091,3090,3089,3088,3087,3086,3085,3084,3082,3081,2987,2986,2985,2984,2983,2982,2981,2980,2949,2811,2808,2803,2800,2558,2553,2485,2482,2480,2478,2475,2473,2472,2471,2470,2469,2467,2466,2462,2460,2459,2458,2457,2456,2455,2454,2453,2452,2451,2449,2448,2416,2405,2403,2301,2297,2296,2295,2294,2293,2292,2291,2290,2288,2287,2286,2284,2283,2282,2280,2278,2276,2275,2274,2273,2272,2271,2270,2269,2268,2266,2264,2262,2261,2260,2259,2256,2255,2254,2253,2252,2251,2250,2249,2246,2215,2214,2209,2204,2203,2105,2104,2103,2102,2101,2100,2098,1996,1995,1994,1993,1992,1991,1990,1989,1988,1987,1986,1985,1984,1983,1982,1981,1980,1979,1744,1743,1742,1741,1740,1739,1738,1732,1731,1650,1649,1647,1646,1645,1644,1643,1641,1638,1637,1636,1633,1631,1622,1620,1619,1617,1615,1612,1611,1610,1609,1589,1588,1582,1581,1580,1579,1578,1577,1576,1575,1543,1529,1450,1449,1448,1447,1446,1445,1444,1417,1406,1405,1359,1358,1357,1356,1355,1354,1349,1348,1347,1346,1345,1344,1196,1195,1192,1186,1140,1137,1135,1132,1130,1129,1128,1127,1122,1119,1116,1115,1072,1071,1070,1069,1068,1067,1066,1065,1064,1062,1061,1060,1059,1058,1057,1056,1044,1043,1040,1038,1036,1025,887,883,831,830,828,827,826,686,664,659,656,654,607,604,603,602,600,599,598,596,595,594,593,592,590,589,588,587,585,584,583,579,575,573,572,571,569,564,563,561,557,556,553,552,550,549,547,546,543,542,538,532,531,530,529,528,527,526,525,524,523,522,521,520,519,518,517,516,515,514,512,511,510,509,508,507,506,505,504,503,502,501,500,499,498,497,496,495,494,493,492,491,490,489,488,487,486,485,484,483,482,481,480,479,478,477,476,475,474,473,472,471,470,469,468,467,466,465,462,461,460,459,458,457,456,455,454,453,452,451,450,449,448,447,446,445,444,443,442,441,440,439,438,437,436,435,433,432,431,430,429,428,427,426,425,424,423,422,421,420,419,418,416,361,360,359,358,357,281,210,127,102), 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 (102,127,210,281,3711,357,358,359,360,361,416,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,505,506,507,508,509,510,511,512,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,538,542,543,546,547,549,550,552,553,556,557,561,563,564,569,571,572,573,575,579,583,584,585,587,588,589,590,592,593,594,595,596,598,599,600,602,603,604,607,654,656,659,664,686,826,827,828,830,831,883,887,1025,1036,1038,1040,1043,1044,1056,1057,1058,1059,1060,1061,1062,1064,1065,1066,1067,1068,1069,1070,1071,1072,1115,1116,1119,1122,1127,1128,1129,1130,1132,1135,1137,1140,1186,1192,1195,1196,1344,1345,1346,1347,1348,1349,1354,1355,1356,1357,1358,1359,1405,1406,1417,1444,1445,1446,1447,1448,1449,1450,1529,1543,1575,1576,1577,1578,1579,1580,1581,1582,1588,1589,1609,1610,1611,1612,1615,1617,1619,1620,1622,1631,1633,1636,1637,1638,1641,1643,1644,1645,1646,1647,1649,1650,1731,1732,1738,1739,1740,1741,1742,1743,1744,1979,1980,1981,1982,1983,1984,1985,1986,1987,1988,1989,1990,1991,1992,1993,1994,1995,1996,2098,2100,2101,2102,2103,2104,2105,2203,2204,2209,2214,2215,2246,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,2282,2283,2284,2286,2287,2288,2290,2291,2292,2293,2294,2295,2296,2297,2301,2403,2405,2416,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,2553,2558,2800,2803,2808,2811,2949,2980,2981,2982,2983,2984,2985,2986,2987,3081,3082,3084,3085,3086,3087,3088,3089,3090,3091,3093,3094,3095,3096,3097,3098,3100,3101,3102,3103,3104,3106,3107,3108,3109,3110,3111,3112,3113,3114,3115,3116,3117,3118,3119,3242,3250,3279,3281,3282,3283,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3300,3301,3302,3303,3304,3305,3306,3307,3308,3309,3314,3315,3317,3318,3320,3321,3322,3323,3324,3325,3326,3327,3328,3329,3330,3332,3334,3337,3338,3339,3347,3348,3349,3357,3363,3366,3367,3370,3372,3378,3379,3380,3381,3384,3385,3462,3395,3397,3398,3399,3400,3401,3402,3403,3404,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3417,3419,3420,3421,3532,3533,3536,3560,3563,3566,3567,3568,3569,3570,3571,3572,3574,3575,3581,3582,3583,3584,3585,3586,3587,3588,3589,3590,3593,3594,3595,3596,3601,3604,3606,3607,3608,3665,3667,3672,3673,3674,3675,3676,3680,3683,3687,3692,3694,3695,3700,3708,3717,3719,3722,3723,3724,3726,3727,3729,3730,3731,3739,3740,3745,3753,3757,3759,3761,3762,3763,3766,3768,3772,3787,3897,4056,3798,3799,3800,3801,3802,3943,3803,3816,3817,3895,3891,4199,4054,4062,3890,3931,3820,3823,3831,3834,3836,3844,3850,3851,3854,3874,3882,3884,3886,3892,3893,3898,3899,3900,3901,3903,3904,3905,3907,3908,3909,3911,3916,3917,3922,3926,3927,3930,3932,3933,3934,3935,3941,3946,3964,3968,3982,3986,3989,3991,3993,3997,4055,4057,4058,4059,4060,4061,4063,4064,4065,4066,4067,4068,4070,4071,4072,4073,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4085,4086,4087,4088,4136,4137,4138,4140,4142,4144,4145,4146,4148,4149,4150,4151,4152,4153,4154,4155,4156,4159,4160,4161,4162,4163,4164,4166,4167,4171,4172,4173,4174,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