| 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 (85,84,84,85,88,10076,87,9968,86,89,88,10076,9968,86,87,89,10076,87,86,9968,88,89,10076,87,9968,86,89,88,90,93,570,9862,569,9861,568,9862,568,569,9861,570,569,568,9862,570,9861,572,8808,573,571,571,8808,573,572,571,8808,572,573,575,574,574,575,577,8809,578,576,576,8809,578,577,576,8809,578,577,580,8810,581,579,579,8810,581,580,579,8810,581,580,582,585,9863,584,8811,586,583,585,9863,583,8811,586,584,584,9863,583,8811,586,585,9863,584,583,8811,585,586,589,10173,588,8812,10099,590,587,10173,587,10099,8812,588,590,589,588,587,10173,10099,8812,589,590,8812,588,587,10099,590,589,10173,1079,8814,1080,1078,1082,1081,1077,1080,8814,1079,1082,1081,1077,1078,1078,8814,1077,1079,1082,1081,1080,1079,1078,1082,8814,1077,1081,1080,1079,1082,8814,1078,1080,1077,1081,1079,8814,1081,1078,1077,1080,1082,1087,8815,1085,1090,1086,1084,1089,1088,1083,1087,8815,1085,1090,1086,1089,1088,1083,1084,1087,8815,1086,1090,1089,1084,1088,1083,1085,1085,8815,1084,1083,1086,1090,1089,1088,1087,1086,1090,8815,1089,1085,1084,1088,1087,1083,1090,1086,8815,1085,1089,1084,1087,1083,1088,1086,1090,8815,1085,1088,1084,1083,1087,1089,1086,8815,1089,1085,1084,1088,1083,1087,1090,3660,4588,4590,4589,4590,4588,4589,4589,4588,4590,4591,4593,4592,4591,4593,4592,4592,4591,4593,4598,9893,4597,9892,4596,9891,4595,9890,4599,4594,4598,9893,4597,9892,4596,9891,4594,9890,4599,4595,4598,9893,4597,9892,4595,9891,4594,9890,4599,4596,4598,9893,4596,9892,4595,9891,4594,9890,4599,4597,9893,4597,4596,9892,4595,9891,4594,9890,4599,4598,9893,4597,4596,9892,4595,9891,4594,9890,4598,4599,9020,9894,4600,4602,4601,4600,9020,9894,4602,4601,4600,9894,4601,9020,4602,4603,9895,4604,4605,4606,4609,9899,4608,9897,4610,4607,4609,9899,4607,9897,4608,4610,4608,9899,4607,9897,4610,4609,4608,9899,4607,9897,4610,4609,4612,9901,4613,9900,4614,9896,4611,4614,9901,4613,9900,4611,9896,4612,4612,9901,4611,9900,4613,9896,4614,4613,4612,9901,4611,9900,4614,9896,4617,9902,4616,9898,4618,4615,4617,9902,9898,4618,4615,4616,4616,9902,4615,9898,4618,4617,4616,9902,4615,9898,4617,4618,5518,5517,5517,5518,5519,5520,5521,5523,5524,5522,5524,5523,5522,5522,5523,5524,5527,9904,5526,9903,5529,9025,5528,5525,5527,9904,9903,5525,5529,9025,5528,5526,5526,9904,5525,9903,5529,9025,5528,5527,5526,9904,5525,9903,5529,9025,5528,5527,9904,5526,5525,9903,5528,9025,5529,5527,5531,5530,5530,5531,5534,9906,5533,9905,5536,9026,5535,5532,5534,9906,5532,9905,5536,9026,5535,5533,5533,9906,5532,9905,5536,9026,5535,5534,5533,9906,5532,9905,5536,9026,5535,5534,5533,9906,5532,9905,9026,5535,5536,5534,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5539,9907,5538,9818,9027,9817,5537,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5539,9907,5537,9818,9027,9817,5538,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5540,9908,5538,9907,5537,9818,9027,9817,5539,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5541,9909,5539,9908,5538,9907,5537,9818,9027,9817,5540,9816,9915,9815,9914,9814,9912,5543,9911,5542,9910,5540,9909,5539,9908,5538,9907,5537,9818,9027,9817,5541,9816,9915,9815,9914,9814,9912,5543,9911,5541,9910,5540,9909,5539,9908,5538,9907,5537,9818,9027,9817,5542,9816,9915,9815,9914,9814,9912,5542,9911,5541,9910,5540,9909,5539,9908,5538,9907,5537,9818,9027,9817,5543,5544,9813,9916,5546,9913,5545,9813,9916,5545,9913,5546,5547,5548,5550,9028,9820,5549,5551,9028,9820,5550,5551,5549,5549,9820,5550,9028,5551,5552,9917,5553,5552,5553,9917,9819,9925,5556,9921,5555,9920,9029,9919,5554,9918,9819,9925,5556,9921,9920,5554,9029,9919,5555,9918,5555,9920,5554,9919,9918,9029,9819,5556,5559,9924,5558,9923,10087,9922,9030,9824,5557,9821,5559,5557,10087,9924,9923,9922,9824,9821,9030,5558,5558,9924,5557,9923,10087,9922,9030,9824,5559,9821,5562,9926,5561,9823,9031,9822,5560,5560,9926,9031,9823,5561,9822,5562,5561,5560,9926,9031,9823,5562,9822,5564,9927,9032,5565,5563,5565,5564,9032,5563,5563,9927,9032,5564,5565,5570,9928,5569,9826,5568,9825,5571,5567,5566,5568,9928,5569,9826,5570,9825,5571,5566,5567,5570,9928,5569,9826,5567,9825,5566,5571,5568,5568,9928,9826,5567,5566,9825,5569,5571,5570,5569,5567,5568,9928,5571,9826,9825,5570,5566,5569,9928,5568,9826,5567,9825,5566,5570,5571,5574,9033,5573,5572,5574,9033,5573,5572,5573,9033,5572,5574,5576,9930,5575,5577,5575,9930,5576,5577,5575,9930,5577,5576,5581,5582,5585,5584,5583,9034,5580,5580,9034,5581,5585,5584,5583,5582,5581,5585,5580,5584,9034,5583,5582,5585,5581,5584,5580,5582,9034,5583,5585,5581,5583,5580,5582,9034,5584,5584,5581,5583,5580,9034,5582,5585,5600,5605,5599,5604,5598,5603,9035,5602,5597,5601,5600,5605,5599,5604,5597,5603,9035,5602,5598,5601,5600,5605,5598,5604,5597,5603,9035,5602,5599,5601,5599,5598,5597,5605,5604,5603,5602,5601,5600,5605,5604,5603,5602,5600,5598,5597,5599,5601,5605,5604,5603,5601,5600,5598,5599,5597,5602,5605,5604,5602,5601,5600,5599,5597,5598,5603,5598,5605,5599,5603,5602,5601,5600,5597,5604,5599,5598,5597,5604,5603,5602,5601,5600,5605,5653,5654,5656,5655,5652,5652,5653,5656,5655,5654,5653,5656,5652,5655,5654,5656,5653,5654,5652,5655,5655,5653,5654,5652,5656,5728,5727,5727,5728,5729,5731,5730,5731,5729,5730,5730,5729,5731,5756,5758,5757,5758,5756,5757,5756,5757,5758,572,571,573,8808,576,577,578,8809,579,580,581,8810,585,583,584,8811,586,587,10099,588,590,8812,589,10173,1078,1082,1079,1077,1081,1080,8814,1085,1090,1086,1084,1089,1088,1083,1087,8815,4601,4600,4602,9020,5526,5525,5529,5528,5527,9025,5533,5532,5534,5536,5535,9026,9027,5543,5540,5541,5537,5539,5538,5542,5549,5550,5551,9028,9819,9925,5556,9921,5555,9920,5554,9919,9029,9918,5558,10087,5559,5557,9030,5560,5561,5562,9031,5564,9927,5565,5563,9032,5572,5574,5573,9033,5581,5585,5580,5583,5582,5584,9034,5605,5604,5603,5602,5601,5598,5600,5597,5599,9035,9813,5545,5546,5539,5542,9027,9814,5541,5538,5543,5537,5540,9814,5539,5542,5543,5541,5538,5540,5537,9027,9815,9027,9816,9817,9815,9814,5540,5543,5537,5538,5542,5539,5541,9027,9817,5543,5540,5537,5538,5541,5539,9816,9815,9814,5542,9814,5543,5542,5541,5540,5539,5537,5538,9027,9817,9816,9815,9818,5554,5555,5556,9819,9029,5549,5550,5551,9028,9820,9821,5558,9030,10087,5557,5559,5560,9031,9822,5561,9823,5562,5560,5561,5562,9822,9031,9823,9924,9923,10087,9922,5559,5557,9821,5558,9030,9824,5568,5567,9825,5569,5566,5571,5570,5568,5569,5567,9826,5566,5571,5570,9825,568,569,9862,570,9861,568,569,9861,570,9862,584,585,583,9863,586,8811,4598,4597,4596,4594,4595,9890,4599,4598,4597,4595,4596,4594,9892,9890,9891,4599,4598,4597,4596,4595,4594,9891,9890,9892,4599,4597,4598,4596,4595,4594,9892,9891,9890,4599,9893,4600,4602,4601,9020,9894,4603,9895,4612,4613,4611,9896,4614,4609,4607,4608,4610,9897,4617,4616,4615,4618,9898,4608,4609,4607,4610,9897,9899,4612,4611,4613,9901,9896,9900,4614,4612,4613,4611,9900,9896,9901,4614,4616,4617,4615,4618,9898,9902,9025,5527,5525,5526,5529,5528,9903,5526,5527,5525,5529,5528,9903,9025,9904,5534,5533,5532,5536,5535,9026,9905,5533,5534,5532,5536,5535,9905,9026,9906,5543,5542,5541,5540,5538,5539,5537,9818,9817,9816,9815,9814,9027,9907,5543,5542,5541,5539,5540,5538,5537,9907,9818,9817,9816,9815,9814,9027,9908,5543,5542,5540,5541,5539,5538,5537,9908,9907,9818,9817,9816,9815,9814,9027,9909,5543,5542,5541,5540,5539,5538,5537,9911,9909,9908,9907,9818,9817,9816,9815,9814,9027,9910,5543,5542,5541,5540,5539,5538,5537,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9911,5539,5542,5541,5543,5538,5540,9911,9910,9909,5537,9908,9907,9818,9817,9816,9815,9814,9027,9912,9813,9913,5546,5545,5539,5542,5538,5541,5543,5537,5540,9912,9911,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9914,5538,5541,5539,5537,5543,5542,5540,9914,9912,9911,9910,9909,9908,9907,9818,9817,9816,9815,9814,9027,9915,5545,5546,9913,9813,9916,5553,9917,5552,9918,9920,9919,9819,5556,5555,5554,9029,5555,9920,9918,9819,5556,5554,9919,9029,5554,5555,9029,9919,9918,9819,5556,9920,5555,5554,9029,9920,9919,9918,9819,5556,9921,9923,9824,5559,9821,5558,5557,10087,9030,9922,9923,5559,5557,10087,9922,9824,9821,5558,9030,5559,5557,10087,9923,9922,9824,9821,5558,9030,9924,5555,5554,9029,9921,9920,9919,9918,9819,5556,9925,5560,5561,9823,9822,9031,9926,5562,9032,5563,5565,5564,9927,5568,5569,5567,5566,5571,9826,9825,9928,5570,5576,5575,5577,9930,88,9968,87,86,89,88,87,86,89,10076,9968,5559,9924,5558,9923,5557,9922,9030,9824,10087,9821,589,10173,8812,588,587,590,10099,587,588,10099,589,10173,590,8812)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.002 | 21 |