| 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 (9827,9932,5579,9931,5578,9929,92,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,585,9863,584,8811,586,583,585,9863,583,8811,586,584,584,9863,583,8811,586,585,9863,584,583,8811,585,586,591,593,594,596,595,592,592,593,596,595,594,593,596,592,595,594,596,593,594,592,595,595,593,594,592,596,599,600,598,597,600,597,599,598,600,597,598,599,599,597,598,600,603,9971,602,604,601,601,9971,602,604,603,602,604,601,9971,603,602,9971,603,601,604,605,607,606,605,607,606,606,605,607,1073,8813,1074,1072,1076,1075,1071,1074,8813,1073,1076,1075,1071,1072,1072,8813,1071,1073,1076,1075,1074,1073,1072,1076,8813,1071,1075,1074,1076,1073,8813,1072,1074,1071,1075,1073,8813,1075,1072,1071,1074,1076,3732,3736,9888,10170,3948,10169,3947,10168,9888,10170,10169,3947,3948,10168,3951,10171,3950,3952,3949,3949,10171,3950,3952,3951,3950,3949,3952,10171,3951,3950,10171,3951,3949,3952,3982,3983,3994,9262,3993,3995,3992,3992,9262,3993,3995,3994,3993,3995,3992,9262,3994,3993,9262,3994,3992,3995,4031,10172,4030,4032,4029,4029,10172,4030,4032,4031,4030,4032,4029,10172,4031,4030,10172,4031,4029,4032,4604,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,9827,9932,5579,9931,92,9929,5578,9827,9932,5578,9931,92,9929,5579,5586,5589,5590,5588,5587,5590,5587,5589,5588,5590,5587,5589,5588,5589,5587,5590,5588,5593,9933,5592,5594,5591,5591,9933,5592,5594,5593,5592,5591,5594,5593,9933,5592,9933,5593,5591,5594,5609,9935,5608,9934,5613,5607,5610,5612,5611,9036,5606,5608,9935,5609,9934,5610,5613,5612,5606,5611,9036,5607,5610,9935,5609,9934,5613,5607,5612,5606,5611,9036,5608,5608,9935,5607,9934,5606,9036,5609,5613,5612,5611,5610,5609,5608,5607,9935,5613,9934,5606,5612,9036,5611,5610,5613,5609,9935,5608,9934,5607,5612,5606,5610,9036,5611,5609,5613,9935,9934,5608,5607,5611,5606,9036,5610,5612,5609,9935,5608,9934,5607,5612,5606,5611,9036,5610,5613,5623,9936,5617,5622,5616,5615,5618,5621,5620,5619,9037,5614,5623,9936,5617,5616,5618,5622,5621,5620,5619,5614,9037,5615,5617,9936,5618,5623,5622,5621,5615,5620,5614,5619,9037,5616,5618,9936,5623,5622,5616,5621,5615,5620,5614,5619,9037,5617,5617,9936,5616,5623,5615,5622,5621,5614,5620,9037,5619,5618,5623,9936,5617,5622,5616,5621,5615,5614,5620,9037,5619,5618,5623,9936,5617,5622,5616,5621,5615,5614,5619,9037,5620,5618,5623,5617,9936,5622,5616,5615,5620,5614,5619,9037,5621,5618,5623,9936,5617,5616,5621,5615,5620,5614,5619,9037,5622,5618,9936,5617,5622,5616,5621,5615,5620,5614,5619,9037,5618,5623,5625,5624,5625,5624,5628,5633,9937,5627,5629,5632,5631,5630,9038,5626,9937,5628,5629,5633,5632,5631,5626,5630,9038,5627,5629,9937,5633,5632,5627,5631,5626,5630,9038,5628,5628,9937,5627,5633,5632,5626,5631,9038,5630,5629,5633,9937,5628,5632,5627,5626,5631,9038,5630,5629,5633,9937,5628,5632,5627,5626,5630,9038,5629,5631,5633,9937,5628,5627,5631,5626,5630,9038,5632,5629,9937,5628,5632,5627,5631,5626,9038,5630,5629,5633,5635,5636,5638,5637,5634,5634,5635,5638,5637,5636,5635,5638,5634,5637,5636,5638,5635,5636,5634,5637,5637,5635,5636,5634,5638,5639,5641,5642,5643,5640,5643,5640,5642,5641,5643,5640,5642,5641,5641,5640,5642,5643,5644,5646,5645,5644,5646,5645,5645,5644,5646,5648,5647,5647,5648,5651,9039,5650,5649,5651,9039,5650,5649,5650,9039,5649,5651,5657,5659,5658,5657,5659,5658,5658,5657,5659,5662,10174,5661,9938,5660,5662,10174,5660,9938,5661,9938,5662,5660,10174,5661,5663,5665,5664,5665,5663,5664,5663,5664,5665,5667,9939,5668,5666,9939,5666,5668,5667,5666,9939,5667,5668,5669,5672,5673,5671,5670,5673,5670,5672,5671,5673,5670,5671,5672,5672,5670,5673,5671,5676,10095,5675,5677,5674,5674,10095,5675,5677,5676,5675,5674,5677,10095,5676,5675,10095,5676,5674,5677,5679,9040,5678,5678,9040,5679,5680,5681,572,571,573,8808,585,583,584,8811,586,1072,1076,1073,1071,1075,1074,8813,5533,5532,5534,5536,5535,9026,5609,5608,9036,5607,5613,5606,5610,5612,5611,5623,5617,5616,5622,5615,5621,5614,5620,5618,5619,9037,9038,5633,5628,5627,5632,5626,5631,5630,5629,5650,5649,5651,9039,5679,5678,9040,3992,3995,3993,3994,9262,92,5579,9827,5578,568,569,9862,570,9861,568,569,9861,570,9862,584,585,583,9863,586,8811,3947,3948,9888,10168,10170,10169,5534,5533,5532,5536,5535,9026,9905,5533,5534,5532,5536,5535,9905,9026,9906,5579,5578,9827,9929,92,5578,5579,9827,92,9929,9931,5578,5579,92,9931,9929,9827,9932,5591,5592,5594,9933,5593,5608,5607,5609,5613,9036,5612,5606,9934,5611,5610,5608,5609,5607,5613,5606,5612,5611,5610,9934,9036,9935,5618,5617,5623,9936,5616,5622,5621,5615,5620,5614,9037,5619,5628,5629,5633,5627,5632,5631,5626,5630,9038,9937,5661,10174,5660,5662,9938,5666,5667,5668,9939,601,604,602,603,9971,5674,10095,5677,5675,5676,3948,10170,3947,10169,10168,9888,10170,3947,3948,10168,10169,9888,3948,3947,10169,10168,10170,9888,3949,3952,3950,3951,10171,4029,4032,4030,4031,10172,5661,5660,9938,10174,5662)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 22 |