| SELECT *
FROM (`shop_products_attributes` AS `spa`)
LEFT JOIN `shop_attributes_values` AS `spv` ON (`spv`.`id_attribute_value` = `spa`.`attribute_value_id`)
LEFT JOIN `shop_attributes_values_description` AS `spvd` ON (`spvd`.`attribute_value_id` = `spa`.`attribute_value_id`)
WHERE `product_id` IN (19,2909,2908,443,444,447,448,450,449,446,446,447,450,449,448,447,450,446,449,448,450,447,448,446,449,449,447,448,446,450,487,488,491,486,490,489,485,487,488,491,490,489,485,486,486,485,491,487,490,489,488,487,491,486,490,485,489,488,491,487,490,486,488,485,489,491,487,489,486,485,488,490,490,487,489,488,486,485,491,498,500,499,498,500,499,499,498,500,502,504,503,504,502,503,502,503,504,518,519,521,520,517,517,518,521,520,519,518,521,517,520,519,521,518,519,517,520,520,518,519,517,521,747,797,799,798,799,797,798,797,798,799,805,801,802,804,803,800,804,805,803,802,800,801,805,801,804,800,803,802,805,804,801,800,802,803,805,801,803,800,804,802,804,803,801,802,800,805,1839,1840,1841,1843,2884,2885,2887,2886,2883,2883,2884,2887,2886,2885,2884,2887,2883,2886,2885,2887,2884,2885,2883,2886,2886,2884,2885,2883,2887,2909,19,2908,19,2908,2909,2911,2912,2914,2913,2910,2910,2911,2914,2913,2912,2911,2914,2910,2913,2912,2914,2911,2912,2910,2913,2913,2911,2912,2910,2914,2918,2919,2917,2916,2919,2918,2916,2917,2919,2916,2918,2917,2918,2916,2919,2917,3041,3042,3043,3044,3137,3136,3137,3136,3556,3557,3555,3554,3557,3556,3554,3555,3557,3554,3555,3556,3556,3554,3555,3557,3678,3674,3675,3677,3676,3673,3677,3678,3676,3675,3673,3674,3678,3674,3677,3673,3676,3675,3678,3677,3674,3673,3676,3675,3678,3674,3676,3673,3677,3675,3677,3676,3674,3675,3673,3678,3704,3711,3716,3717,3718,3738,3739,3741,3740,3737,3737,3738,3741,3740,3739,3738,3741,3737,3740,3739,3741,3738,3739,3737,3740,3740,3738,3739,3737,3741,3804,3809,3803,3808,3805,3802,3807,3806,3801,3804,3805,3809,3803,3808,3807,3806,3801,3802,3804,3805,3809,3808,3807,3802,3806,3801,3803,3803,3802,3801,3809,3804,3808,3807,3806,3805,3804,3803,3809,3802,3808,3807,3801,3806,3805,3809,3804,3808,3807,3803,3802,3805,3801,3806,3809,3804,3808,3803,3806,3802,3801,3805,3807,3809,3804,3803,3807,3806,3802,3801,3805,3808,3808,3807,3804,3806,3803,3805,3802,3801,3809,3877,3876,3872,3873,3871,3875,3874,3870,3877,3872,3876,3875,3873,3874,3870,3871,3876,3877,3875,3873,3874,3871,3870,3872,3877,3872,3876,3871,3875,3870,3874,3873,3877,3876,3872,3875,3871,3870,3873,3874,3877,3876,3872,3874,3871,3870,3873,3875,3877,3872,3875,3871,3874,3870,3873,3876,3876,3875,3872,3874,3871,3870,3877,3873,3881,3880,3880,3881,3928,3930,3929,3929,3930,3932,3931,3932,3931,4358,4359,4405,4411,4407,4408,4410,4409,4406,4410,4411,4409,4408,4406,4407,4411,4407,4410,4406,4409,4408,4411,4410,4407,4406,4409,4408,4411,4407,4409,4406,4410,4408,4410,4407,4409,4406,4408,4411,4418,4421,4422,4423,4424,4425,4428,4429,4427,4426,4429,4426,4428,4427,4429,4426,4427,4428,4428,4426,4427,4429,4430,4521,4548,4549,4547,4546,4549,4546,4548,4547,4549,4546,4548,4547,4548,4546,4549,4547,4566,4567,4568,4577,4578,4576,4575,4578,4575,4577,4576,4578,4575,4576,4577,4577,4575,4578,4576,4579,4580,4635,4634,4635,4634,4638,4639,4641,4640,4642,8765,4637,4637,8765,4642,4638,4641,4640,4639,4638,4642,4637,4641,8765,4640,4639,4642,4638,4641,4637,4639,8765,4640,4642,4638,4640,4639,4637,8765,4641,4641,4640,4638,4639,4637,8765,4642,4644,4645,4647,4646,4643,4643,4644,4647,4646,4645,4644,4647,4643,4646,4645,4647,4644,4645,4643,4646,4646,4644,4645,4643,4647,4653,4649,4650,4652,4651,4648,4652,4653,4651,4650,4648,4649,4653,4649,4652,4648,4651,4650,4653,4652,4649,4648,4651,4650,4653,4649,4651,4648,4652,4650,4652,4651,4649,4648,4653,4650,4665,4671,4670,4664,4663,4669,4666,4662,4668,4667,4661,4665,4671,4666,4664,4670,4663,4669,4668,4667,4661,4662,4665,4666,4671,4664,4670,4669,4668,4662,4667,4661,4663,4665,4666,4671,4670,4669,4663,4668,4662,4667,4661,4664,4664,4663,4662,4661,4671,4665,4670,4669,4668,4667,4666,4665,4664,4671,4663,4670,4669,4662,4668,4661,4667,4666,4671,4665,4670,4669,4664,4668,4663,4662,4666,4661,4667,4671,4665,4670,4669,4664,4663,4667,4662,4661,4666,4668,4671,4665,4670,4664,4668,4663,4662,4667,4661,4666,4669,4671,4665,4664,4669,4668,4663,4662,4667,4661,4666,4670,4670,4665,4669,4668,4667,4664,4663,4662,4666,4661,4671,4679,4678,4674,4675,4673,4677,4676,4672,4679,4674,4678,4677,4675,4676,4672,4673,4678,4679,4677,4675,4676,4673,4672,4674,4679,4674,4673,4678,4677,4672,4676,4675,4679,4678,4674,4677,4673,4672,4675,4676,4679,4678,4674,4676,4673,4672,4675,4677,4679,4674,4677,4673,4676,4672,4675,4678,4678,4674,4677,4676,4673,4672,4675,4679,4687,4686,4682,4683,4681,4685,4684,4680,4687,4682,4686,4685,4683,4684,4680,4681,4686,4687,4685,4683,4684,4681,4680,4682,4687,4682,4681,4686,4685,4680,4684,4683,4687,4686,4682,4685,4681,4680,4683,4684,4687,4686,4682,4684,4681,4680,4685,4683,4687,4682,4685,4681,4684,4680,4686,4683,4686,4685,4682,4684,4681,4680,4687,4683,4699,4698,4694,4695,4693,4697,4696,4692,4699,4694,4698,4697,4695,4696,4692,4693,4698,4699,4697,4695,4696,4693,4692,4694,4699,4694,4693,4698,4697,4692,4696,4695,4699,4698,4694,4697,4693,4692,4695,4696,4699,4698,4694,4696,4693,4692,4697,4695,4699,4694,4697,4693,4696,4692,4698,4695,4698,4697,4694,4696,4693,4692,4699,4695,4703,4705,4707,4706,4707,4705,4706,4705,4706,4707,4708,5067,5770,5776,5775,5769,5768,5774,5771,5767,5773,5772,5766,5770,5776,5771,5769,5775,5768,5774,5773,5772,5766,5767,5770,5771,5776,5769,5775,5774,5773,5767,5772,5766,5768,5770,5771,5776,5775,5774,5768,5773,5767,5772,5766,5769,5769,5768,5767,5766,5776,5770,5775,5774,5773,5772,5771,5770,5769,5776,5768,5775,5767,5774,5773,5766,5772,5771,5776,5770,5775,5774,5769,5773,5768,5767,5771,5766,5772,5776,5770,5775,5774,5769,5768,5772,5767,5766,5771,5773,5776,5770,5775,5769,5768,5773,5767,5772,5766,5771,5774,5776,5770,5774,5769,5773,5768,5767,5772,5766,5771,5775,5775,5770,5774,5773,5772,5769,5768,5767,5771,5766,5776,5779,5780,5783,5778,5782,5781,5777,5779,5780,5783,5782,5781,5777,5778,5778,5777,5783,5779,5782,5781,5780,5779,5783,5778,5782,5777,5781,5780,5783,5779,5782,5778,5780,5777,5781,5783,5779,5781,5778,5777,5780,5782,5782,5779,5781,5780,5778,5777,5783,5792,10006,5787,5786,5791,5788,5785,5790,5789,5784,10006,5787,5792,5786,5788,5791,5790,5789,5784,5785,10006,5787,5791,5792,5788,5790,5785,5789,5784,5786,5792,10006,5791,5788,5790,5789,5786,5785,5784,5787,10006,5787,5786,5792,5785,5791,5790,5784,5789,5788,10006,5792,5787,5791,5786,5790,5785,5784,5788,5789,5792,10006,5787,5791,5786,5785,5789,5784,5788,5790,10006,5787,5792,5786,5790,5785,5789,5784,5791,5788,10006,5787,5791,5786,5790,5785,5789,5784,5792,5788,5793,5795,5796,5798,5797,5794,5794,5795,5798,5797,5796,5795,5798,5794,5797,5796,5798,5795,5796,5794,5797,5797,5795,5796,5794,5798,5801,5802,5805,5800,5804,5803,5799,5801,5802,5805,5804,5803,5799,5800,5800,5799,5805,5801,5804,5803,5802,5801,5805,5800,5804,5799,5803,5802,5805,5801,5804,5800,5802,5799,5803,5805,5801,5800,5803,5799,5802,5804,5804,5801,5803,5802,5800,5799,5805,5808,5809,5807,5806,5809,5808,5806,5807,5809,5806,5807,5808,5808,5806,5807,5809,5814,5820,5819,5813,5812,5818,5815,5811,5817,5816,5810,5814,5820,5815,5813,5819,5812,5818,5817,5816,5810,5811,5814,5815,5820,5813,5819,5818,5817,5811,5816,5810,5812,5814,5815,5820,5819,5818,5812,5817,5811,5816,5810,5813,5813,5812,5811,5810,5820,5814,5819,5818,5817,5816,5815,5814,5813,5820,5812,5819,5818,5811,5817,5810,5816,5815,5820,5814,5819,5818,5813,5817,5812,5811,5815,5810,5816,5820,5814,5819,5818,5813,5812,5816,5811,5810,5815,5817,5820,5814,5819,5813,5817,5812,5811,5816,5810,5815,5818,5820,5814,5818,5813,5817,5812,5811,5816,5810,5815,5819,5819,5814,5818,5817,5816,5813,5812,5815,5811,5810,5820,5824,5829,5823,5828,5825,5822,5827,5826,5821,5824,5825,5829,5823,5828,5827,5826,5821,5822,5824,5825,5829,5828,5827,5822,5826,5821,5823,5823,5822,5821,5829,5824,5828,5827,5826,5825,5824,5823,5829,5822,5828,5827,5821,5826,5825,5829,5824,5828,5827,5823,5822,5825,5821,5826,5829,5824,5828,5823,5826,5822,5821,5825,5827,5829,5824,5827,5823,5826,5822,5821,5825,5828,5828,5824,5827,5826,5825,5823,5822,5821,5829,6223,6224,6222,6221,6224,6223,6221,6222,6224,6221,6223,6222,6223,6221,6224,6222,6229,6234,6228,6233,6230,6227,6232,6231,6226,6229,6230,6234,6228,6233,6232,6231,6226,6227,6229,6230,6234,6233,6232,6227,6231,6226,6228,6228,6227,6226,6234,6229,6233,6232,6231,6230,6229,6228,6234,6227,6233,6232,6226,6231,6230,6234,6229,6233,6232,6228,6227,6230,6226,6231,6234,6229,6233,6228,6231,6227,6226,6230,6232,6234,6229,6228,6232,6231,6227,6226,6230,6233,6233,6229,6232,6231,6228,6230,6227,6226,6234,6238,6397,6398,6401,6396,6400,6399,6395,6397,6398,6401,6400,6399,6395,6396,6396,6395,6401,6397,6400,6399,6398,6397,6401,6396,6400,6395,6399,6398,6401,6397,6400,6396,6398,6395,6399,6401,6397,6399,6396,6395,6398,6400,6400,6397,6399,6398,6396,6395,6401,6423,10069,6422,6421,10069,6421,6423,6422,10069,6421,6423,6422,6466,6467,6465,6464,6467,6466,6464,6465,6467,6464,6466,6465,6466,6464,6467,6465,6482,6483,6485,6484,6481,6481,6482,6485,6484,6483,6482,6485,6481,6484,6483,6485,6482,6483,6481,6484,6484,6482,6483,6481,6485,6581,6588,6589,6591,6590,6591,6590,6975,6976,6974,6973,6976,6973,6975,6974,6976,6973,6975,6974,6975,6973,6974,6976,7825,7852,7853,7855,7854,7851,7851,7852,7855,7854,7853,7852,7855,7851,7854,7853,7855,7852,7853,7851,7854,7854,7852,7853,7851,7855,7857,7856,7857,7856,7858,7859,7919,7918,7919,7918,7921,7922,7924,7923,7920,7920,7921,7924,7923,7922,7921,7924,7920,7923,7922,7924,7921,7922,7920,7923,7923,7921,7922,7920,7924,7925,7926,7928,7927,7926,7928,7927,7927,7926,7928,7929,7931,7930,7931,7929,7930,7929,7930,7931,7935,7936,7934,7933,7936,7933,7935,7934,7936,7933,7935,7934,7935,7933,7936,7934,7944,7943,7939,7940,7938,7942,7941,7937,7944,7939,7943,7942,7940,7941,7937,7938,7943,7944,7942,7940,7941,7938,7937,7939,7944,7939,7943,7938,7942,7937,7941,7940,7944,7943,7939,7942,7938,7937,7941,7940,7944,7943,7939,7938,7941,7937,7940,7942,7944,7939,7942,7938,7941,7937,7943,7940,7943,7939,7942,7941,7938,7937,7944,7940,7945,7948,8039,8040,8041,8042,8102,8136,8137,8143,8146,8147,8172,8191,8198,8277,8278,8319,8320,8325,8580,8581,8582,8583,8584,8585,8634,8686,8695,8713,8714,8724,8726,8727,8745,8746,8747,8748,8749,8750,8751,8752,9974,9991,9973,4638,4639,4642,4641,4637,4640,8765,8766,9019,9177,9176,9176,9177,9180,9181,9179,9178,9181,9180,9178,9179,9181,9178,9179,9180,9180,9178,9179,9181,9216,9215,9215,9216,9217,9246,9251,9245,9250,9247,9244,9249,9248,9243,9246,9247,9251,9245,9250,9249,9248,9243,9244,9246,9247,9251,9250,9249,9244,9248,9243,9245,9245,9244,9243,9251,9246,9250,9249,9248,9247,9246,9245,9251,9244,9250,9249,9243,9248,9247,9251,9246,9250,9249,9245,9244,9247,9243,9248,9251,9246,9250,9245,9248,9244,9243,9247,9249,9251,9246,9245,9249,9248,9244,9243,9247,9250,9250,9246,9249,9248,9247,9245,9244,9243,9251,9259,9258,9254,9255,9253,9257,9256,9252,9259,9254,9258,9257,9255,9256,9252,9253,9258,9259,9257,9255,9256,9253,9252,9254,9259,9254,9258,9253,9257,9252,9256,9255,9259,9258,9254,9257,9253,9252,9255,9256,9259,9258,9254,9253,9256,9252,9257,9255,9259,9254,9257,9253,9256,9252,9258,9255,9258,9254,9257,9256,9253,9252,9255,9259,9319,9394,9457,9951,9952,9960,9991,8758,9974,9973,9991,8758,9973,9974,9974,8758,9973,9991,5792,5787,5791,5788,5790,5786,5789,5785,5784,10006,10014,10013,10009,10010,10008,10012,10011,10007,10014,10009,10013,10012,10010,10011,10007,10008,10013,10014,10012,10010,10011,10008,10007,10009,10014,10009,10013,10008,10012,10007,10011,10010,10014,10013,10009,10012,10008,10007,10010,10011,10014,10013,10009,10008,10011,10007,10010,10012,10014,10009,10012,10008,10011,10007,10013,10010,10013,10012,10009,10011,10008,10007,10014,10010,10021,10022,10023,10020,10019,10021,10020,10019,10022,10023,10022,10019,10020,10023,10021,10023,10021,10020,10019,10022,10020,10022,10023,10021,10019,6423,6421,10069,6422)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |