| 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 (2921,2920,2921,2920,6247,6242,6246,6243,6245,6244,9069,6241,6246,6247,6245,6243,6244,6241,9069,6242,6247,6242,6241,6246,6245,9069,6244,6243,6247,6246,6242,6241,6245,9069,6243,6244,6247,6246,6242,6241,6244,9069,6243,6245,6247,6242,6245,6241,6244,9069,6246,6243,6246,6242,6245,6244,6241,9069,6247,6243,6250,9070,6249,6248,6250,9070,6248,6249,6249,9070,6248,6250,6253,6272,6266,6263,6271,6265,6270,6264,6269,6268,9074,6262,6267,6266,6272,6265,6271,6270,6264,6262,6269,6268,9074,6263,6267,6272,6266,6271,6265,6270,6263,6269,6268,6262,9074,6267,6264,6271,6272,6270,6266,6269,6268,6267,6264,6263,6262,9074,6265,6264,6265,6263,6262,6272,6271,6270,6269,6268,9074,6267,6266,6272,6271,6265,6270,6264,6269,6263,6262,6268,9074,6267,6266,6272,6271,6265,6270,6264,6269,6262,6263,9074,6267,6268,6266,6272,6271,6265,6270,6264,6263,6268,6262,6267,9074,6269,6266,6272,6265,6271,6264,6269,6263,6268,6262,6267,9074,6266,6270,6272,6265,6264,6270,6269,6263,6262,6268,6267,9074,6266,6271,6271,6270,6265,6269,6264,6268,6263,6267,6262,9074,6266,6272,6283,6276,6282,6281,6275,6274,6277,6280,6279,6278,9075,6273,6283,6276,6282,6275,6277,6281,6280,6279,6278,6273,9075,6274,6283,6276,6281,6282,6280,6277,6274,6279,6278,6273,9075,6275,6282,6283,6281,6277,6280,6279,6275,6278,6274,6273,9075,6276,6276,6283,6275,6282,6274,6281,6280,6273,6279,9075,6278,6277,6283,6282,6276,6281,6275,6280,6274,6273,6279,9075,6278,6277,6283,6282,6276,6281,6275,6280,6274,6273,6278,9075,6277,6279,6283,6282,6276,6281,6275,6274,6279,6273,6278,6277,9075,6280,6283,6282,6276,6275,6280,6274,6279,6273,6278,9075,6277,6281,6283,6276,6281,6280,6275,6274,6279,6273,9075,6278,6277,6282,6282,6281,6276,6280,6275,6279,6274,6278,6273,9075,6283,6277,9089,6645,6648,6647,6646,6645,9089,6648,6647,6646,6648,6645,6646,9089,6647,6647,6645,6646,9089,6648,6247,6242,6246,6241,6245,6243,6244,9069,6248,6250,6249,9070,9074,6272,6265,6271,6264,6270,6263,6269,6262,6268,6267,6266,6283,6276,6282,6275,6281,6274,6280,6273,6279,6278,6277,9075,6646,6645,6647,6648,9089,10136,10137,10138,10139,10140,10141)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 6 |