1153 Got a packet bigger than 'max_allowed_packet' bytes
in:
[SELECT count(DISTINCT p2a.products_id) as quantity, po.products_options_name, pov.products_options_values_name, SUM(IF(p2a.products_id IN(1976,1977,1978,1979,1980,1981,1982,1983,1984,1985,1986,2069,2070,2071,2072,2073,2074,2075,2076,2077,2078,2079,2080,2081,2082,2083,2084,2085,2086,2087,2088,2089,2090,2091,2092,2093,2094,2095,2096,2097,2098,2099,2100,2101,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,2116,2117,2118,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2130,2131,2132,2133,2134,2203,2204,2205,2206,2207,2208,2209,2210,2211,2212,2213,2214,2215,2216,2217,2218,2219,2220,2221,2222,2448,2449,2450,2451,2452,2453,2454,2455,2456,2457,2458,2459,2460,2461,2462,2463,2464,2465,2466,2467,2468,2469,2575,2576,2577,2578,2579,2580,2581,2582,2583,2584,2585,2586,2587,2588,2589,2590,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2616,2617,2618,2619,2620,2621,2622,2623,2624,2625,2626,2627,2628,2629,2630,2631,2682,2683,2684,2685,2686,2687,2688,2689,2690,2691,2692,2693,2694,2695,2696,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2711,2712,2713,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2778,2779,2780,2781,2782,2783,2784,2785,2786,2787,2788,2789,2790,2791,2792,2793,2794,3160,3161,3162,3163,3164,3165,3166,3167,3168,3169,3170,3171,3172,3173,3174,3175,3176,3177,3178,3179,3180,3181,3182,3183,3184,3185,3186,3187,3188,3189,3190,3191,3192,3193,3194,3195,3196,3197,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3219,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3237,3238,3239,3240,3241,3242,3243,3244,3245,3246,3247,3248,3249,3250,3251,3252,3273,3274,3275,3276,3277,3278,3279,3280,3281,3282,3283,3284,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,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3325,3326,3327,3328,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3390,3391,3392,3393,3394,3395,3396,3397,3398,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3824,3825,3826,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3837,3838,3839,3840,3841,3842,3843,3844,4049,4050,4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4061,4062,4063,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4090,4091,4092,4093,4094,4095,4155,4156,4157,4158,4159,4160,4161,4162,4163,4164,4165,4166,4167,4168,4169,4170,4171,4172,4173,4174,4175,4176,4177,4178,4179,4180,4181,4182,4183,4184,4185,4186,4187,4188,4189,4190,4191,4192,4193,4194,4195,4196,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4212,4213,4214,4215,4216,4217,4218,4219,4220,4221,4222,4223,4224,4225,4226,4227,4228,4229,4230,4231,4232,4233,4234,4235,4236,4237,4238,4239,4240,4241,4242,4243,4244,4245,4246,4247,4248,4249,4250,4251,4252,4253,4254,4255,4256,4257,4258,4259,4260,4261,4262,4263,4264,4265,4266,4267,4268,4269,4270,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4308,4309,4310,4311,4312,4313,4314,4315,4316,4317,4318,4319,4320,4321,4322,4323,4324,4325,4326,4327,4328,4329,4330,4331,4332,4333,4334,4335,4336,4337,4338,4339,4340,4341,4342,4343,4344,4345,4346,4347,4348,4349,4350,4351,4352,4353,4354,4355,4356,4357,4358,4359,4360,4361,4362,4363,4364,4365,4366,4367,4368,4369,4370,4371,4372,4373,4374,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4394,4395,4396,4397,4398,4399,4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4566,4567,4568,4569,4570,4571,4572,4573,4574,4575,4576,4577,4578,5383,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399,5400,5401,5402,5403,5404,5643,5644,5645,5646,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5660,5661,5662,5663,5664,5665,5666,5667,5668,5669,5670,5671,5672,5673,5674,5675,5676,5677,5678,5679,5746,5747,5748,5749,5750,5751,5752,5753,5754,5885,5886,5887,5888,5889,5890,5891,5892,5893,5894,5895,5896,5897,5898,5899,5900,5901,5902,5903,5904,5905,5906,5907,5908,5909,5910,5911,5912,5913,5914,5915,5916,5917,5918,5919,5920,5921,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5948,5949,5950,5951,5952,5953,5954,5955,5956,5957,5958,5959,5960,5961,5962,5963,5964,5965,5966,5967,5968,5973,5974,5975,5976,5977,5978,5979,5980,5981,5982,5983,5984,5985,5986,5987,5988,5989,5990,5991,5992,5993,5994,5995,5996,5997,5998,5999,6000,6001,6002,6003,6004,6005,6006,6045,6046,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,6067,6068,6069,6070,6071,6086,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,6098,6099,6100,6101,6102,6103,6104,6105,6106,6107,6108,6109,6110), 1, 0)) as flag FROM products_attributes p2a JOIN products_options po ON p2a.options_id = po.products_options_id AND po.language_id=1 JOIN products_options_values pov ON p2a.options_values_id = pov.products_options_values_id AND pov.language_id=1 WHERE p2a.products_id IN (1976,1977,1978,1979,1980,1981,1982,1983,1984,2119,2120,2121,2122,2123,2124,2125,2126,2127,2128,2129,2203,2204,2205,2206,2207,2208,2209,2074,2075,2076,2077,2217,2218,2219,2220,2221,2078,2079,2080,2081,2082,2083,2069,2070,2084,2085,2086,2087,2088,2089,2090,2091,2071,2072,2073,2098,2099,2100,2101,2616,2617,2618,2619,2620,2621,2622,2575,2576,2577,2578,2579,2580,2581,2591,2592,2593,2594,2595,2596,2597,2598,2599,2600,2601,2602,2448,2449,2450,2451,2457,2682,2683,2684,2685,2686,2687,2688,2763,2764,2765,2766,2767,2768,2769,2770,2771,2772,2773,2774,2775,2776,2777,2689,2690,2691,2692,2693,2694,2695,2696,2736,2737,2738,2739,2740,2741,2742,2743,2744,2745,2746,2747,2748,2749,2750,2751,2724,2725,2726,2727,2728,2729,2730,2731,2732,2733,2734,2735,2778,2779,2780,2781,2782,2783,2784,2785,2786,2752,2753,2754,2755,2756,2757,2758,2759,2760,2761,2762,2697,2698,2699,2700,2701,2702,2703,2704,2705,2706,2707,2708,2709,2710,2787,2788,2789,2790,2791,2792,2793,2794,2714,2715,2716,2717,2718,2719,2720,2721,2722,2723,2711,2712,2713,2210,2211,2212,2213,2214,2215,2216,3247,3248,3249,3250,3251,3252,2222,3175,3176,3177,3178,3179,3180,3181,3182,3168,3169,3170,3171,3172,3173,3174,3212,3213,3214,3244,3215,3216,3245,3246,3217,3209,3210,3211,3163,3164,3165,3166,3167,3222,3223,3224,3225,3226,3227,3228,3229,3160,3161,3187,3188,3189,3190,3191,3192,2092,2093,2094,2095,2096,3162,3193,3194,3195,3196,3197,3198,3199,3200,2102,2103,2104,2105,2106,2107,2108,2109,2110,2111,2112,2113,2114,2115,3237,3238,3239,3240,3241,3242,3243,2623,2624,2625,2626,2627,3390,3391,3392,3393,3394,3395,3396,3397,3398,3358,3359,3360,3361,3362,3363,3364,3365,3366,3367,3368,3369,3370,3371,3372,3373,3374,3375,3376,3377,3378,3379,3380,3381,3382,3383,3384,3385,3386,3387,3388,3389,3348,3349,3350,3351,3352,3353,3354,3355,3356,3357,3301,3302,3303,3304,3305,3306,3285,3286,3287,3288,3289,3290,3291,3292,3293,3294,3295,3296,3297,3298,3299,3300,3307,3308,3309,3310,3311,3312,3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3325,3326,3327,3328,3276,3277,3278,3279,3280,3281,3282,3283,3403,3404,3405,3406,3407,3408,3409,3410,3411,3412,3413,3414,3415,3416,3284,3273,3274,3275,2582,2583,2584,2585,2586,2587,2588,2589,2590,3528,3529,3530,3531,3532,3533,3534,3535,3536,3537,3517,3518,3519,3520,3521,3522,3523,3524,3525,3526,3527,2452,2453,2454,3201,3202,3203,3204,3205,3206,3207,3208,3827,3828,3829,3830,3831,3832,3833,3834,3835,3836,3824,3825,3826,2458,2459,2460,2461,2462,2463,2464,3837,3838,3839,3840,3841,3842,3843,3844,2465,2466,2467,2468,2469,3183,3184,3185,3186,4049,4050,4051,4052,4053,4054,4055,4056,4057,4058,4059,4060,4090,4091,4092,4093,4094,4074,4075,4076,4077,4078,4079,4080,4081,4082,4083,4084,4085,4086,4087,4088,4089,4095,4186,4187,4188,4189,4249,4250,4251,4252,4190,4191,4192,4193,4194,4195,4196,4171,4172,4173,4174,4175,4176,4177,4178,4179,4248,4180,4181,4182,4183,4184,4185,4155,4156,4157,4158,4159,4160,4161,4162,4163,4164,4165,4166,4167,4168,4169,4170,4197,4198,4199,4200,4201,4202,4203,4204,4205,4206,4207,4208,4209,4210,4211,4212,4213,4214,4215,4216,4217,4218,4219,4220,4221,4222,4223,4224,4225,4226,4227,4228,4229,4230,4263,4264,4265,4266,4267,4268,4269,4270,4271,4272,4273,4274,4275,4276,4277,4278,4279,4280,4281,4282,4283,4284,4285,4286,4287,4288,4289,4290,4291,4292,4293,4294,4295,4296,4297,4298,4299,4300,4301,4302,4303,4304,4305,4306,4307,4308,4331,4332,4333,4334,4335,4336,4337,4338,4339,4340,4341,4342,4343,4344,4345,4346,4309,4310,4311,4312,4313,4314,4315,4316,4317,4318,4319,4320,4321,4322,4323,4324,4325,4326,4231,4232,4233,4234,4235,4236,4327,4328,4329,4330,4237,4412,4413,4238,4239,4240,4241,4242,4243,4244,4245,4246,4247,4347,4348,4349,4350,4351,4352,4353,4354,4355,4356,4357,4358,4359,4360,4361,4362,4363,4414,4415,4416,4417,4418,4419,4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4259,4260,4261,4262,4253,4254,4255,4256,4257,4258,4384,4385,4386,4387,4388,4389,4390,4391,4392,4393,4394,4395,4396,4397,4398,4399,4566,4567,4568,4569,4570,4571,4572,4573,4574,4575,4576,4577,4578,4372,4373,4374,4364,4365,4366,4367,4368,4369,4370,4371,5400,5401,5402,5403,5404,5384,5385,5386,5387,5388,5389,5390,5391,5392,5393,5394,5395,5396,5397,5398,5399,5383,5643,5644,5645,5646,5647,5648,5649,5650,5651,5652,5653,5654,5655,5656,5657,5658,5659,5660,5661,5662,5663,5664,5665,5666,5667,5668,5746,5747,5748,5749,5750,5751,5752,5753,5754,1985,1986,2130,2131,2132,2133,2134,5675,5676,5677,5678,5679,5669,5670,5671,5672,5673,5674,4061,3218,3219,3220,3221,4062,4063,5948,5949,5950,5951,5952,2097,5953,5954,5955,5956,5957,5958,5959,5960,2116,2117,2118,5895,5896,5897,5898,5899,5900,5901,5902,5919,5920,5921,5922,5923,5924,5925,5926,5927,5928,5929,5930,5931,5932,5933,5934,5903,5904,5905,5906,5907,5908,5909,5910,5911,5912,5913,5885,5886,5887,5888,5889,5890,5914,5915,5916,5917,5918,5891,5892,5893,5894,2628,2629,2630,2631,5994,5995,5996,5997,5998,5999,6000,6001,6002,6003,6004,6005,6006,5989,5990,5991,5992,5993,5973,5974,5975,5976,5977,5978,5979,5980,6086,6087,6088,6089,6090,6091,6092,6093,6094,6095,6096,6097,5981,5982,5983,5984,5985,5986,5987,5988,6045,6046,6047,6048,6049,6050,6051,6052,6053,6054,6055,6056,6057,6058,6059,6060,6061,6062,6063,6064,6065,6066,2455,2456,5961,5962,5963,5964,5965,5966,5967,5968,6098,6099,6100,6101,6102,6103,6104,6105,6106,6107,6108,6109,6110,6069,6070,6071,6067,6068) GROUP BY po.products_options_name, pov.products_options_values_name ORDER BY po.products_options_name, pov.products_options_values_sort_order]