| 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 (443,483,484,482,481,484,483,481,482,484,481,483,482,483,481,484,482,495,497,496,497,495,496,495,496,497,498,500,499,498,500,499,499,498,500,502,504,503,504,502,503,502,503,504,505,511,510,510,511,522,523,747,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,1360,1437,1436,1432,1433,1431,1435,1434,1430,1437,1432,1436,1435,1433,1434,1430,1431,1436,1437,1435,1433,1434,1431,1430,1432,1437,1432,1436,1431,1435,1430,1434,1433,1437,1436,1432,1435,1431,1430,1434,1433,1437,1436,1432,1431,1434,1430,1435,1433,1437,1432,1435,1431,1434,1430,1436,1433,1436,1432,1435,1434,1431,1430,1433,1437,1450,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,1597,1598,1600,1599,1596,1596,1597,1600,1599,1598,1597,1600,1596,1599,1598,1600,1597,1598,1596,1599,1599,1597,1598,1596,1600,1616,1612,1611,1615,1614,1613,8847,1610,1616,1612,1615,1614,1610,8847,1611,1613,1611,1616,1615,1610,1614,8847,1613,1612,1616,1615,1611,1614,1610,8847,1612,1613,1616,1611,1615,1610,8847,1613,1612,1614,1616,1611,1612,1614,1613,1610,8847,1615,1615,1614,1611,1613,1610,8847,1612,1616,1628,1627,1621,1626,1620,1619,1625,1622,1618,1624,1623,1617,1628,1621,1627,1626,1620,1622,1619,1625,1624,1623,1617,1618,1628,1621,1627,1626,1620,1625,1622,1624,1618,1623,1617,1619,1628,1621,1626,1627,1625,1622,1619,1624,1618,1623,1617,1620,1627,1628,1626,1622,1625,1624,1620,1623,1619,1618,1617,1621,1621,1628,1620,1619,1627,1626,1618,1625,1624,1617,1623,1622,1628,1627,1626,1621,1620,1625,1619,1624,1618,1617,1623,1622,1628,1627,1621,1626,1625,1620,1619,1618,1623,1617,1624,1622,1628,1627,1621,1626,1620,1619,1624,1618,1623,1617,1622,1625,1628,1627,1621,1620,1625,1619,1624,1618,1623,1617,1622,1626,1628,1621,1626,1625,1620,1624,1619,1618,1623,1617,1622,1627,1627,1626,1621,1625,1620,1624,1619,1623,1618,1617,1628,1622,1631,1632,1635,1630,1634,1633,1629,1631,1632,1635,1634,1633,1629,1630,1630,1629,1635,1631,1634,1633,1632,1631,1635,1630,1634,1629,1633,1632,1635,1631,1634,1630,1632,1629,1633,1635,1631,1633,1630,1629,1632,1634,1634,1631,1633,1632,1630,1629,1635,1636,1639,1640,1643,1638,1642,1641,1637,1639,1640,1643,1642,1641,1637,1638,1638,1637,1643,1639,1642,1641,1640,1639,1643,1638,1642,1637,1641,1640,1643,1639,1642,1638,1640,1637,1641,1643,1639,1641,1638,1637,1640,1642,1642,1639,1641,1640,1638,1637,1643,1646,1647,1650,1645,1649,1648,1644,1646,1647,1650,1649,1648,1644,1645,1645,1644,1650,1646,1649,1648,1647,1646,1650,1645,1649,1644,1648,1647,1650,1646,1649,1645,1647,1644,1648,1650,1646,1645,1648,1644,1647,1649,1649,1648,1646,1647,1645,1644,1650,1695,1700,1694,1699,1696,1693,1698,1697,1692,1695,1696,1700,1694,1699,1698,1697,1692,1693,1695,1696,1700,1699,1698,1693,1697,1692,1694,1694,1693,1692,1700,1695,1699,1698,1697,1696,1695,1694,1700,1693,1699,1698,1692,1697,1696,1700,1695,1699,1698,1694,1693,1696,1692,1697,1700,1695,1699,1694,1697,1693,1692,1696,1698,1700,1695,1698,1694,1697,1693,1692,1696,1699,1699,1695,1698,1697,1694,1696,1693,1692,1700,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,1717,1721,1723,1722,1723,1721,1722,1722,1721,1723,1724,1726,1725,1724,1726,1725,1724,1725,1726,1823,1839,1840,1841,1843,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,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,3042,3043,3044,3224,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,9716,8685,9673,9674,9675,9676,9717,9717,9674,9673,9675,8685,9676,9716,9717,8685,9716,9674,9673,9675,9676,9717,8685,9716,9674,9675,9673,9676,9717,8685,9716,9674,9673,9675,9676,9717,8685,9716,9674,9673,9675,9676,9717,8685,9716,9674,9673,9675,9676,9717,9716,8685,9673,9674,3506,9675,9676,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,3523,3524,3527,3522,3526,3525,3521,3523,3524,3527,3526,3525,3521,3522,3522,3521,3527,3523,3526,3525,3524,3523,3527,3522,3526,3521,3525,3524,3527,3523,3526,3522,3524,3521,3525,3527,3523,3525,3522,3521,3524,3526,3526,3525,3523,3524,3522,3521,3527,3529,3531,3530,3531,3529,3530,3529,3530,3531,3537,3538,3540,3539,3536,3536,3537,3540,3539,3538,3537,3540,3536,3539,3538,3540,3537,3538,3536,3539,3539,3537,3538,3536,3540,3711,3716,3717,3718,3906,3907,3905,3904,3907,3906,3904,3905,3907,3904,3905,3906,3906,3904,3905,3907,4358,4359,4418,4421,4636,4878,4879,5064,5067,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,5094,5095,5097,5104,5106,5105,5104,5106,5105,5105,5104,5106,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,5268,5436,5808,5809,5807,5806,5809,5808,5806,5807,5809,5806,5807,5808,5808,5806,5807,5809,5833,6229,6234,6228,6233,6230,6227,6232,6231,6226,6229,6230,6234,6228,6233,6232,6231,6226,6227,6229,6230,6234,6233,6232,6227,6231,6226,6228,6228,6227,6226,6234,6229,6233,6232,6231,6230,6229,6228,6234,6227,6233,6232,6226,6231,6230,6234,6229,6233,6232,6228,6227,6230,6226,6231,6234,6229,6233,6228,6231,6227,6226,6230,6232,6234,6229,6228,6232,6231,6227,6226,6230,6233,6233,6229,6232,6231,6228,6230,6227,6226,6234,6238,6311,6312,6310,6309,6312,6311,6309,6310,6312,6309,6310,6311,6311,6309,6312,6310,6409,6411,6410,6411,6409,6410,6409,6410,6411,6419,6519,6520,6522,6521,6518,6518,6519,6522,6521,6520,6519,6522,6518,6521,6520,6522,6519,6520,6518,6521,6521,6519,6520,6518,6522,6581,6908,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,6957,6958,7078,7079,7077,7076,7079,7076,7078,7077,7079,7076,7077,7078,7078,7076,7079,7077,7090,7091,7089,7088,7091,7090,7088,7089,7091,7088,7090,7089,7090,7088,7089,7091,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,7190,7825,7905,7906,7908,7907,7904,7904,7905,7908,7907,7906,7905,7908,7904,7907,7906,7908,7905,7906,7904,7907,7907,7905,7906,7904,7908,7913,7912,7912,7913,7919,7918,7919,7918,7925,7959,7960,7962,7961,7958,7958,7959,7962,7961,7960,7959,7962,7958,7961,7960,7962,7959,7960,7958,7961,7961,7959,7960,7958,7962,8101,8205,8341,8569,8571,8610,3500,9717,3499,3506,9716,3505,9674,3504,9673,3503,9675,3502,9676,3501,8685,8686,8687,1616,1611,1610,1615,1614,1612,1613,8847,2939,2944,2943,2938,2937,2941,2942,2940,8984,9019,7171,7175,7170,7172,7174,7173,9107,9592,9593,9596,9591,9595,9594,9590,9592,9593,9596,9595,9594,9590,9591,9591,9590,9596,9592,9595,9594,9593,9592,9596,9591,9595,9590,9594,9593,9596,9592,9595,9591,9593,9590,9594,9596,9592,9591,9594,9590,9593,9595,9595,9592,9594,9593,9591,9590,9596,9659,9662,9661,9660,9658,9662,9658,9660,9661,9659,9659,9660,9658,9662,9661,9660,9662,9659,9661,9658,9659,9660,9661,9658,9662,9717,3500,3499,3506,8685,3505,9716,3504,9674,3503,9675,3502,9676,3501,9673,9717,3500,3499,3506,8685,3505,9716,3504,3503,9673,9675,3502,9676,3501,9674,9717,3500,3499,3506,8685,3505,9716,3504,3503,9674,9673,3502,9676,3501,9675,9717,3500,3499,3506,8685,3505,9716,3504,3503,9674,3502,9673,9675,3501,9676,9717,3500,3499,3506,8685,3505,9674,3504,9673,3503,9675,3502,9676,3501,9716,3499,3506,8685,3505,9716,3504,9674,3503,9673,3502,9675,3501,9676,3500,9717,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 | 11 |