| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1868,1873,1872,1867,1871,1866,1869,1870,24,1329,1345,1346,1344,1370,1366,1369,1367,1368,1365,1372,1382,1383,1381,1399,1405,1400,1398,1404,1403,1396,1402,1395,1401,1397,1639,1640,1643,1642,1637,1641,1638,1649,1648,1647,1645,1644,1650,1646,1656,1655,1651,1653,1654,1652,1673,1671,1670,1672,1719,1720,1718,1722,1721,1723,1725,1726,1724,1740,1741,1743,1739,1742,1768,1773,1772,1771,1767,1766,1769,1770,1780,1781,1782,1785,1786,1788,1787,1784,1795,1790,1794,1789,1792,1793,1791,1817,1815,1819,1820,1814,1818,1816,1821,1844,5100,5105,5106,5104,5417,5418,5419,5420,5422,5421,5423,5424,5425,5427,5428,5426,5432,5434,5430,5435,5429,5433,5431,5436,5437,5439,5440,5438,5445,5441,5443,5444,5442,5447,5448,5450,5449,5446,5454,5458,5453,5457,5455,5456,5459,6337,6341,6340,6336,6338,6339,6342,6344,6391,6389,6388,6390,6440,6530,6529,6524,6528,6526,6523,6527,6525,6574,6909,6912,6910,6911,7914,7915,7916,7960,7958,7961,7962,7959,8114,8115,8153,8161,8171,8565,8567,8568,8570,8572,8574,8575,8602,8609,8620,8681,8706,8848,9126,9578,9579,9577,9580,9701,9700,9702,9712,9713,9714,9743,9744,9742,9745,9767,9768,9771,9769,9770,9772,9785,9781,9784,9783,9782,9789,9787,9791,9792,9790,9786,9788,9796,9800,9798,9799,9797,10247,10245,10244,10246,10251,10249,10248,10250,10253,10254,10252) | 0.001 | 1214 |
| 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 (1868,1873,1867,1872,1869,1866,1871,1870,24,1329,1344,1346,1345,1346,1344,1345,1344,1345,1346,1370,1366,1367,1369,1368,1365,1369,1370,1368,1367,1365,1366,1370,1366,1369,1365,1368,1367,1370,1369,1366,1365,1367,1368,1370,1366,1368,1365,1367,1369,1369,1368,1366,1365,1370,1367,1372,1381,1383,1382,1383,1381,1382,1382,1381,1383,1399,1405,1404,1398,1397,1403,1400,1396,1402,1401,1395,1399,1405,1400,1398,1404,1397,1403,1402,1401,1395,1396,1399,1400,1405,1398,1404,1403,1402,1396,1401,1395,1397,1399,1400,1405,1404,1403,1397,1402,1396,1401,1395,1398,1398,1397,1396,1395,1405,1399,1404,1403,1402,1401,1400,1399,1398,1405,1397,1404,1403,1396,1402,1395,1401,1400,1405,1399,1404,1403,1398,1402,1397,1396,1400,1395,1401,1405,1399,1404,1403,1398,1397,1401,1396,1395,1400,1402,1405,1399,1404,1398,1402,1397,1396,1401,1395,1400,1403,1405,1399,1403,1398,1402,1397,1396,1401,1395,1400,1404,1404,1399,1403,1402,1398,1401,1397,1396,1400,1395,1405,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,1656,1652,1653,1655,1654,1651,1655,1656,1654,1653,1651,1652,1656,1652,1655,1651,1654,1653,1656,1655,1652,1651,1653,1654,1656,1652,1654,1651,1653,1655,1655,1654,1652,1651,1653,1656,1672,1673,1671,1670,1673,1670,1672,1671,1673,1670,1672,1671,1672,1670,1671,1673,1718,1720,1719,1720,1718,1719,1718,1719,1720,1721,1723,1722,1723,1721,1722,1722,1721,1723,1724,1726,1725,1724,1726,1725,1724,1725,1726,1740,1741,1743,1742,1739,1739,1740,1743,1742,1741,1740,1743,1739,1742,1741,1743,1740,1741,1739,1742,1742,1740,1741,1739,1743,1773,1772,1768,1769,1767,1771,1770,1766,1773,1768,1772,1771,1769,1770,1766,1767,1772,1773,1771,1769,1770,1767,1766,1768,1773,1768,1767,1772,1771,1766,1770,1769,1773,1772,1768,1771,1767,1766,1770,1769,1773,1772,1768,1767,1770,1766,1771,1769,1773,1768,1771,1767,1770,1766,1769,1772,1772,1768,1771,1770,1767,1766,1773,1769,1781,1780,1781,1780,1782,1785,1786,1788,1787,1784,1784,1785,1788,1787,1786,1785,1788,1784,1787,1786,1788,1785,1786,1784,1787,1787,1785,1786,1784,1788,1791,1792,1795,1790,1794,1793,1789,1791,1792,1795,1794,1793,1789,1790,1790,1789,1795,1791,1794,1793,1792,1791,1795,1790,1794,1789,1793,1792,1795,1791,1794,1790,1792,1789,1793,1795,1791,1793,1790,1789,1792,1794,1794,1791,1793,1792,1790,1789,1795,1816,1817,1820,1815,1819,1818,1814,1816,1817,1820,1819,1818,1814,1815,1815,1814,1820,1816,1819,1818,1817,1816,1820,1815,1819,1814,1818,1817,1820,1816,1819,1815,1817,1814,1818,1820,1816,1815,1818,1814,1817,1819,1819,1816,1818,1817,1815,1814,1820,1821,1844,1868,1869,1873,1867,1872,1871,1870,24,1866,1868,1869,1873,1872,1871,1866,1870,24,1867,1867,1866,24,1873,1868,1872,1871,1870,1869,1868,1867,1873,1866,1872,1871,24,1870,1869,1873,1868,1872,1871,1867,1866,1869,24,1870,1873,1868,1872,1867,1870,1866,24,1869,1871,1873,1868,1871,1867,1870,1866,24,1869,1872,1872,1868,1871,1870,1867,1869,1866,24,1873,5100,5104,5106,5105,5104,5106,5105,5105,5104,5106,5417,5418,5420,5419,5419,5420,5421,5423,5422,5423,5421,5422,5421,5422,5423,5424,5425,5426,5428,5427,5426,5428,5427,5426,5427,5428,5431,5432,5435,5430,5434,5433,5429,5431,5432,5435,5434,5433,5429,5430,5430,5429,5435,5431,5434,5433,5432,5431,5435,5430,5434,5429,5433,5432,5435,5431,5434,5430,5432,5429,5433,5435,5431,5433,5430,5429,5432,5434,5434,5431,5433,5432,5430,5429,5435,5436,5437,5438,5440,5439,5440,5438,5439,5438,5439,5440,5442,5443,5445,5444,5441,5441,5442,5445,5444,5443,5442,5445,5441,5444,5443,5445,5442,5443,5441,5444,5444,5442,5443,5441,5445,5447,5448,5450,5449,5446,5446,5447,5450,5449,5448,5447,5450,5446,5449,5448,5450,5447,5448,5446,5449,5449,5447,5448,5446,5450,5458,5454,5455,5457,5456,5453,5457,5458,5456,5455,5453,5454,5458,5454,5457,5453,5456,5455,5458,5457,5454,5453,5456,5455,5458,5454,5456,5453,5455,5457,5457,5454,5456,5453,5458,5455,5459,6337,6341,6338,6340,6339,6336,6340,6341,6338,6339,6336,6337,6337,6336,6341,6340,6339,6338,6341,6340,6337,6336,6339,6338,6341,6337,6339,6336,6340,6338,6340,6337,6339,6336,6341,6338,6342,6344,6390,6391,6389,6388,6391,6388,6390,6389,6391,6388,6390,6389,6390,6388,6389,6391,6440,6530,6529,6525,6526,6524,6528,6527,6523,6530,6525,6529,6528,6526,6527,6523,6524,6529,6530,6528,6526,6527,6524,6523,6525,6530,6525,6529,6524,6528,6523,6527,6526,6530,6529,6525,6528,6524,6523,6527,6526,6530,6529,6525,6524,6527,6523,6526,6528,6530,6525,6528,6524,6527,6523,6526,6529,6529,6528,6525,6527,6524,6523,6526,6530,6574,6911,6912,6910,6909,6912,6911,6909,6910,6912,6909,6910,6911,6911,6909,6912,6910,7914,7916,7915,7915,7916,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,8114,8115,8153,8161,8171,8565,8567,8568,8570,8572,8574,8575,8602,8609,8620,8681,8706,8848,9126,9577,9579,9578,9579,9577,9578,9577,9578,9579,9580,9700,9702,9701,9700,9702,9701,9701,9700,9702,9712,9714,9713,9713,9714,9742,9744,9743,9744,9742,9743,9743,9742,9744,9745,9767,9768,9771,9772,9770,9769,9772,9769,9771,9770,9772,9769,9770,9771,9771,9769,9772,9770,9785,9782,9784,9783,9781,9784,9781,9783,9782,9785,9784,9785,9782,9781,9783,9783,9785,9782,9781,9784,9782,9781,9784,9785,9783,9788,9789,9792,9787,9791,9790,9786,9788,9789,9792,9791,9790,9786,9787,9787,9786,9792,9788,9791,9790,9789,9788,9792,9787,9791,9786,9790,9789,9792,9788,9791,9787,9789,9786,9790,9792,9788,9787,9790,9786,9789,9791,9791,9788,9790,9789,9787,9786,9792,9797,9798,9800,9799,9796,9796,9797,9800,9799,9798,9797,9800,9796,9799,9798,9800,9797,9798,9796,9799,9799,9797,9798,9796,9800,10246,10247,10245,10244,10247,10244,10246,10245,10247,10244,10246,10245,10246,10244,10245,10247,10250,10251,10249,10248,10251,10248,10250,10249,10251,10248,10250,10249,10250,10248,10249,10251,10252,10254,10253,10254,10252,10253,10252,10253,10254)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |