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