| 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 (478,8800,479,609,610,612,611,608,608,609,612,611,610,609,612,608,611,610,612,609,610,608,611,611,609,610,608,612,9012,9014,3890,9013,4709,9021,4710,5066,5098,5515,5516,5514,5513,5516,5513,5515,5514,5516,5513,5514,5515,5515,5513,5514,5516,6480,6476,6477,6479,6478,6475,6479,6480,6478,6477,6475,6476,6480,6476,6479,6475,6478,6477,6480,6479,6476,6475,6477,6478,6480,6476,6478,6475,6477,6479,6479,6478,6476,6477,6475,6480,7108,8201,7106,7113,7105,7112,8200,7111,7104,7110,8201,7108,7106,7113,7112,7104,8200,7111,7105,7110,7108,8201,7113,7112,7105,7104,8200,7111,7106,7110,7106,7105,7104,8201,7113,7112,7111,8200,7110,7108,8201,7113,7106,7112,7111,7105,7104,8200,7108,7110,8201,7113,7106,7112,7105,7104,7110,8200,7111,7108,7106,8201,7113,7105,7104,7111,8200,7110,7112,7108,7106,8201,7105,7112,7111,7104,8200,7110,7113,7108,9109,9108,7300,7301,7303,7302,7303,7301,7302,7302,7301,7303,7304,7308,7307,7308,7307,7311,7312,7310,7309,7312,7309,7311,7310,7312,7309,7311,7310,7311,7309,7312,7310,7314,7315,7317,7316,7313,7313,7314,7317,7316,7315,7314,7317,7313,7316,7315,7317,7314,7315,7313,7316,7316,7314,7315,7313,7317,7318,7320,7319,7320,7318,7319,7319,7318,7320,7321,7323,7322,7323,7321,7322,7322,7321,7323,7326,7327,7325,7324,7327,7326,7324,7325,7327,7324,7326,7325,7326,7324,7327,7325,7331,7336,7330,7335,7332,7329,7334,7333,7328,7331,7332,7336,7330,7335,7334,7333,7328,7329,7331,7332,7336,7335,7334,7329,7333,7328,7330,7330,7329,7328,7336,7331,7335,7334,7333,7332,7331,7330,7336,7329,7335,7334,7328,7333,7332,7336,7331,7335,7334,7330,7329,7332,7328,7333,7336,7331,7335,7330,7333,7329,7328,7332,7334,7336,7331,7330,7334,7333,7329,7328,7332,7335,7335,7331,7334,7333,7330,7332,7329,7328,7336,7339,7340,7343,7338,7342,7341,7337,7339,7340,7343,7342,7341,7337,7338,7338,7337,7343,7339,7342,7341,7340,7339,7343,7338,7342,7337,7341,7340,7343,7339,7342,7338,7340,7337,7341,7343,7339,7341,7338,7337,7340,7342,7342,7339,7341,7340,7338,7337,7343,7346,7347,7350,7345,7349,7348,7344,7346,7347,7350,7349,7348,7344,7345,7345,7344,7350,7346,7349,7348,7347,7346,7350,7345,7349,7344,7348,7347,7350,7346,7349,7345,7347,7344,7348,7350,7346,7348,7345,7344,7347,7349,7349,7346,7348,7347,7345,7344,7350,7352,7353,7355,7354,7351,7351,7352,7355,7354,7353,7352,7355,7351,7354,7353,7355,7352,7353,7351,7354,7354,7352,7353,7351,7355,7358,7359,7357,7356,7359,7358,7356,7357,7359,7356,7358,7357,7358,7356,7359,7357,7365,7361,7362,7364,7363,7360,7364,7365,7363,7362,7360,7361,7365,7361,7364,7360,7363,7362,7365,7364,7361,7360,7363,7362,7365,7361,7363,7360,7362,7364,7364,7363,7361,7360,7362,7365,7366,7368,7367,7368,7366,7367,7367,7366,7368,7371,7372,7370,7369,7372,7371,7369,7370,7372,7369,7371,7370,7371,7369,7372,7370,7956,8092,8093,8201,7106,7113,7105,7112,7104,7108,7111,7110,8200,7106,7105,7111,7113,7110,7112,7104,8200,8201,7108,9113,9112,8207,9016,9015,8715,478,8800,3890,9014,9013,9012,3890,9014,9012,9013,3890,9013,9014,9012,8715,9015,9016,9015,9016,8715,4709,9021,7300,9109,9108,9108,7300,9109,9110,9111,8207,9112,9113,9112,9113,8207,9353,9354,9347,9349,9348,9352,9351,9346,9345,9350,9353,9347,9349,9351,9346,9345,9353,9354,9351,9349,9348,9352,9346,9345,9347,9350,9353,9351,9349,9347,9345,9346,9348,9348,9354,9347,9346,9352,9353,9351,9345,9349,9350,9353,9348,9346,9350,9351,9347,9345,9349,9348,9354,9353,9347,9352,9346,9350,9345,9349,9351,9353,9347,9349,9351,9350,9348,9346,9352,9345,9348,9354,9352,9351,9347,9346,9345,9350,9349,9353,9353,9349,9347,9351,9345,9352,9350,9348,9346,9354,9363,9364,9357,9359,9358,9362,9361,9356,9355,9360,9363,9357,9359,9361,9355,9356,9363,9364,9361,9359,9358,9362,9356,9355,9357,9360,9359,9363,9361,9357,9355,9356,9358,9358,9364,9357,9356,9362,9363,9361,9355,9359,9360,9363,9361,9358,9356,9360,9359,9357,9355,9358,9364,9363,9357,9362,9356,9360,9355,9359,9361,9363,9357,9359,9361,9360,9358,9356,9355,9362,9358,9364,9362,9361,9357,9356,9355,9360,9359,9363,9363,9361,9359,9357,9355,9362,9360,9358,9356,9364,9975,9977,9976,9975,9977,9976,9976,9975,9977)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 1 |