| 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 (495,497,496,497,495,496,495,496,497,792,788,789,791,790,787,791,792,790,789,787,788,792,788,791,787,790,789,792,791,788,787,789,790,792,788,790,787,791,789,791,790,788,787,792,789,795,796,794,793,796,793,795,794,796,793,794,795,795,793,794,796,806,808,807,808,806,807,807,806,808,1343,1416,1417,1415,1414,1417,1416,1414,1415,1417,1414,1416,1415,1416,1414,1417,1415,1429,1428,1423,1422,1427,1424,1421,1426,1425,1420,1429,1423,1428,1422,1424,1427,1426,1425,1420,1421,1429,1423,1427,1428,1424,1426,1421,1425,1420,1422,1428,1429,1427,1424,1426,1425,1422,1421,1420,1423,1423,1429,1422,1428,1421,1427,1426,1420,1425,1424,1429,1428,1423,1427,1422,1426,1421,1420,1424,1425,1429,1428,1423,1427,1422,1421,1425,1420,1424,1426,1429,1423,1428,1422,1426,1421,1425,1420,1427,1424,1429,1423,1427,1422,1426,1421,1425,1420,1428,1424,1428,1427,1423,1426,1422,1425,1421,1420,1424,1429,1453,1454,1452,1451,1454,1451,1453,1452,1454,1451,1453,1452,1453,1451,1452,1454,1460,1456,1457,1459,1458,1455,1459,1460,1458,1457,1455,1456,1460,1456,1459,1455,1458,1457,1460,1459,1456,1455,1457,1458,1460,1456,1458,1455,1459,1457,1459,1456,1458,1455,1460,1457,1461,1463,1462,1461,1463,1462,1461,1462,1463,1491,1487,1488,1490,1489,1486,1490,1491,1489,1488,1486,1487,1491,1487,1490,1486,1489,1488,1491,1490,1487,1486,1488,1489,1491,1487,1489,1486,1490,1488,1490,1489,1487,1488,1486,1491,9778,9777,1530,9776,9775,1529,1528,1527,9774,1526,9773,1525,1524,1530,9778,1529,1528,9777,1527,9776,1526,9775,9774,1524,9773,1525,1530,9778,1529,1528,9777,1527,9776,9775,1525,9774,9773,1524,1526,1530,9778,1529,1528,9777,9776,1526,9775,9774,1525,9773,1524,1527,1530,9778,1529,9777,9776,1527,1526,9775,9774,1525,9773,1524,1528,1530,9778,1528,9777,1527,9776,9775,1526,9774,1525,9773,1524,1529,1529,9778,1528,1527,1526,9777,9776,1525,9775,9774,1524,9773,1530,1587,1589,1588,1589,1587,1588,1587,1588,1589,1708,1710,1709,1710,1708,1709,1709,1708,1710,1714,1715,1713,1712,1715,1714,1712,1713,1715,1712,1713,1714,1714,1712,1713,1715,1846,1847,1849,1848,1845,1845,1846,1849,1848,1847,1846,1849,1845,1848,1847,1849,1846,1847,1845,1848,1848,1846,1847,1845,1849,1865,1864,1860,1861,1859,1863,1862,1858,1865,1860,1864,1863,1861,1862,1858,1859,1864,1865,1863,1861,1862,1859,1858,1860,1865,1860,1864,1859,1863,1858,1862,1861,1865,1864,1860,1863,1859,1858,1862,1861,1865,1864,1860,1862,1859,1858,1863,1861,1865,1860,1863,1859,1862,1858,1861,1864,1864,1863,1860,1862,1859,1858,1861,1865,1874,1876,1875,1876,1874,1875,1875,1874,1876,2935,2934,2934,2935,2936,2939,2944,2940,2938,2943,2942,2941,8984,2937,2939,2940,2944,2943,2942,2937,2941,8984,2938,2938,2937,8984,2939,2944,2943,2942,2941,2940,2939,2938,2944,2943,2937,2942,8984,2941,2940,2944,2939,2943,2938,2942,2937,2940,8984,2941,2944,2939,2943,2938,2941,2937,8984,2940,2942,2944,2939,2942,2938,2937,2941,8984,2940,2943,2943,2939,2942,2941,2938,2937,8984,2940,2944,3231,3232,3245,3241,3242,3244,3243,3240,3244,3245,3243,3242,3240,3241,3245,3241,3244,3240,3243,3242,3245,3244,3241,3240,3242,3243,3245,3241,3243,3240,3242,3244,3244,3241,3243,3240,3242,3245,3251,3247,3248,3250,3249,3246,3250,3251,3249,3248,3246,3247,3251,3247,3250,3246,3249,3248,3251,3250,3247,3246,3249,3248,3251,3247,3249,3246,3250,3248,3250,3249,3247,3246,3248,3251,3253,3254,3256,3255,3252,3252,3253,3256,3255,3254,3253,3256,3252,3255,3254,3256,3253,3254,3252,3255,3255,3253,3254,3252,3256,3262,3258,3259,3261,3260,3257,3261,3262,3260,3259,3257,3258,3262,3258,3261,3257,3260,3259,3262,3261,3258,3257,3260,3259,3262,3258,3260,3257,3259,3261,3261,3258,3260,3257,3262,3259,3511,3512,3510,3509,3512,3511,3509,3510,3512,3509,3510,3511,3511,3509,3510,3512,3520,3519,3515,3516,3514,3518,3517,3513,3520,3515,3519,3518,3516,3517,3513,3514,3519,3520,3518,3516,3517,3514,3513,3515,3520,3515,3514,3519,3518,3513,3517,3516,3520,3519,3515,3518,3514,3513,3516,3517,3520,3519,3515,3517,3514,3513,3518,3516,3520,3515,3518,3514,3517,3513,3519,3516,3519,3518,3515,3517,3514,3513,3516,3520,3666,3662,3663,3665,3664,3661,3665,3666,3664,3663,3661,3662,3666,3662,3665,3661,3664,3663,3666,3665,3662,3661,3663,3664,3666,3662,3664,3661,3663,3665,3665,3662,3664,3661,3663,3666,3672,3668,3669,3671,3670,3667,3671,3672,3670,3669,3667,3668,3672,3668,3671,3667,3670,3669,3672,3671,3668,3667,3669,3670,3672,3668,3670,3667,3671,3669,3671,3670,3668,3669,3667,3672,5074,5076,5075,5074,5076,5075,5074,5075,5076,5077,5079,5078,5079,5077,5078,5078,5077,5079,5080,5082,5081,5082,5080,5081,5081,5080,5082,5095,5217,5218,5221,5216,5220,5219,5215,5217,5218,5221,5220,5219,5215,5216,5216,5215,5221,5217,5220,5219,5218,5217,5221,5216,5220,5215,5219,5218,5221,5217,5220,5216,5218,5215,5219,5221,5217,5219,5216,5215,5218,5220,5220,5217,5219,5218,5216,5215,5221,5234,5235,5237,5236,5233,5233,5234,5237,5236,5235,5234,5237,5233,5236,5235,5237,5234,5235,5233,5236,5236,5234,5235,5233,5237,5238,5240,5241,5243,5242,5239,5239,5240,5243,5242,5241,5240,5243,5239,5242,5241,5243,5240,5241,5239,5242,5242,5240,5241,5239,5243,6920,6919,6915,6916,6914,6918,6917,6913,6920,6915,6919,6918,6916,6917,6913,6914,6919,6920,6918,6916,6917,6914,6913,6915,6920,6915,6914,6919,6918,6913,6917,6916,6920,6919,6915,6918,6914,6913,6917,6916,6920,6919,6915,6917,6914,6913,6916,6918,6920,6915,6918,6914,6917,6913,6916,6919,6919,6915,6918,6917,6914,6913,6920,6916,7150,7151,7149,7148,7151,7150,7148,7149,7151,7148,7150,7149,7150,7148,7151,7149,7152,7154,7153,7154,7152,7153,7152,7153,7154,7155,7157,7156,7155,7157,7156,7155,7156,7157,7166,7167,7169,7168,7165,7165,7166,7169,7168,7167,7166,7169,7165,7168,7167,7169,7166,7167,7165,7168,7168,7166,7167,7165,7169,7171,7172,7175,7174,7173,9107,7170,7170,9107,7171,7175,7174,7173,7172,7171,7175,7170,7174,9107,7173,7172,7175,7171,7174,7170,7172,9107,7173,7175,7171,7173,7170,7172,9107,7174,7174,7171,7173,7170,7172,9107,7175,7178,7179,7182,7177,7181,7180,7176,7178,7179,7182,7181,7180,7176,7177,7177,7176,7182,7178,7181,7180,7179,7178,7182,7177,7181,7176,7180,7179,7182,7178,7181,7177,7179,7176,7180,7182,7178,7180,7177,7176,7179,7181,7181,7178,7180,7179,7177,7176,7182,8095,8341,8566,2939,2944,2943,2938,2937,2941,2942,2940,8984,7171,7175,7170,7172,7174,7173,9107,9778,1530,1529,9777,1528,9776,9775,1527,1524,9774,1526,1525,9773,9778,1530,9777,1529,9776,1528,1524,9775,1527,1526,1525,9773,9774,9778,1530,9777,1529,1524,9776,1528,1527,1526,9774,1525,9773,9775,9778,1524,1530,9777,1529,1528,1527,9775,1526,9774,1525,9773,9776,9778,1524,1530,1529,1528,9776,1527,9775,1526,9774,1525,9773,9777,9777,9776,9775,9774,9773,1530,9778,1529,1528,1527,1526,1525,1524,10255,10257,10256,10257,10255,10256,10255,10256,10257)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 5 |