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