| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (1353,1371,1409,1406,1407,1408,1413,1410,1412,1411,1429,1423,1428,1427,1424,1421,1426,1420,1425,1422,1454,1451,1452,1453,1456,1460,1455,1459,1457,1458,1462,1463,1461,1494,1499,1498,1493,1496,1492,1495,1497,1508,1507,1502,1505,1501,1504,1500,1503,1506,1588,1587,1589,5091,5092,5108,5109,5107,5110,5112,5113,5114,5115,5117,5116,5118,5121,5120,5119,5122,5123,5124,5128,5127,5125,5126,5129,5133,5131,5130,5132,5134,5135,5137,5138,5136,5139,5140,5142,5143,5141,5144,5145,5147,5146,5148,5149,5157,5160,5159,5158,5163,5167,5166,5162,5164,5165,5161,5169,5170,5168,5171,5176,5175,5174,5177,5179,5178,5180,5190,5191,5200,5198,5197,5199,5202,5201,5203,5209,5210,5213,5214,5212,5217,5221,5220,5216,5218,5215,5219,5228,5229,5230,5231,5232,5235,5233,5236,5237,5234,5240,5241,5243,5239,5242,5247,5244,5245,5246,5465,5466,6533,8044,8099,8107,8120,8138,8168,8271,8333,8334,8562,8563,8573,8579,8608,8671,8986,9043,9081,9082,9127,9460,9459,9458,9473,9474,9462,9461,10117,9464,9465,9466,9463,9468,9469,9467,9475,9477,9476,9478,9480,9479,9485,9486,9487,9484,9491,9489,9488,9490,9492,9495,9493,9494,9761,9760,9758,9759,9762,9756,9765,9764,9763,9757,9778,1530,1524,9777,1529,1528,9775,1527,9774,1526,9773,1525,9776,9780,9803,9802,9801,9805,9804,9806,10038,10040,10039,10037,10239,10240,10238,10242,10243,10241) | 0.001 | 1171 |
| 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 (1353,1371,1408,1409,1407,1406,1409,1406,1408,1407,1409,1406,1408,1407,1408,1406,1409,1407,1412,1413,1411,1410,1413,1410,1412,1411,1413,1410,1411,1412,1412,1410,1413,1411,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,1499,1498,1494,1495,1493,1497,1496,1492,1499,1494,1498,1497,1495,1496,1492,1493,1498,1499,1497,1495,1496,1493,1492,1494,1499,1494,1498,1493,1497,1492,1496,1495,1499,1498,1494,1497,1493,1492,1495,1496,1499,1498,1494,1496,1493,1492,1497,1495,1499,1494,1497,1493,1496,1492,1495,1498,1498,1494,1497,1496,1493,1492,1499,1495,1503,1508,1502,1507,1504,1501,1506,1505,1500,1503,1504,1508,1502,1507,1506,1505,1500,1501,1503,1504,1508,1507,1506,1501,1505,1500,1502,1502,1501,1500,1508,1503,1507,1506,1505,1504,1503,1502,1508,1501,1507,1506,1500,1505,1504,1508,1503,1507,1506,1502,1501,1504,1500,1505,1508,1503,1507,1502,1505,1501,1500,1504,1506,1508,1503,1502,1506,1505,1501,1500,1504,1507,1507,1503,1506,1505,1502,1504,1501,1500,1508,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,5092,5091,5092,5091,5107,5109,5108,5109,5107,5108,5107,5108,5109,5110,5113,5112,5113,5112,5115,5114,5115,5114,5116,5118,5117,5118,5116,5117,5117,5116,5118,5119,5121,5120,5119,5121,5120,5120,5119,5121,5123,5122,5122,5123,5124,5126,5127,5129,5128,5125,5125,5126,5129,5128,5127,5126,5129,5125,5128,5127,5129,5126,5127,5125,5128,5128,5126,5127,5125,5129,5132,5133,5131,5130,5133,5130,5132,5131,5133,5130,5131,5132,5132,5130,5131,5133,5134,5135,5136,5138,5137,5136,5138,5137,5136,5137,5138,5139,5140,5141,5143,5142,5143,5141,5142,5141,5142,5143,5144,5145,5147,5146,5146,5147,5148,5149,5159,5160,5158,5157,5160,5157,5159,5158,5160,5157,5158,5159,5159,5157,5160,5158,5163,5164,5167,5162,5166,5165,5161,5163,5164,5167,5166,5165,5161,5162,5162,5161,5167,5163,5166,5165,5164,5163,5167,5162,5166,5161,5165,5164,5167,5163,5166,5162,5164,5161,5165,5167,5163,5165,5162,5161,5164,5166,5166,5163,5165,5164,5162,5161,5167,5168,5170,5169,5170,5168,5169,5169,5168,5170,5171,5176,5177,5175,5174,5177,5176,5174,5175,5177,5174,5176,5175,5176,5174,5177,5175,5178,5180,5179,5180,5178,5179,5179,5178,5180,5191,5190,5191,5190,5199,5200,5198,5197,5200,5197,5199,5198,5200,5197,5199,5198,5199,5197,5200,5198,5201,5203,5202,5203,5201,5202,5202,5201,5203,5210,5209,5210,5209,5212,5214,5213,5212,5214,5213,5213,5212,5214,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,5228,5230,5229,5229,5230,5232,5231,5232,5231,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,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,5246,5247,5245,5244,5247,5244,5246,5245,5247,5244,5246,5245,5246,5244,5245,5247,5466,5465,5466,5465,6533,8044,8099,8107,8120,8138,8168,8271,8333,8334,8562,8563,8573,8579,8608,8671,8986,9043,9081,9082,9127,9460,9459,9458,9459,9458,9460,9459,9460,9458,9473,9474,9462,10117,9461,10117,9474,9473,9461,9462,9464,9465,9466,9463,9465,9463,9466,9464,9464,9466,9463,9465,9464,9465,9463,9466,9468,9467,9469,9467,9469,9468,9467,9469,9468,9461,9473,9462,10117,9474,9473,9461,9462,10117,9474,9476,9477,9479,9478,9480,9475,9475,9477,9478,9480,9479,9476,9475,9479,9478,9476,9480,9477,9475,9480,9477,9476,9479,9478,9475,9477,9476,9480,9478,9479,9475,9478,9476,9477,9479,9480,9485,9486,9487,9484,9487,9486,9484,9485,9487,9485,9484,9486,9485,9486,9484,9487,9491,9489,9490,9488,9490,9491,9488,9489,9491,9489,9490,9488,9490,9489,9491,9488,9494,9495,9493,9492,9495,9492,9494,9493,9495,9492,9494,9493,9494,9492,9495,9493,9757,9763,9765,9764,9756,9756,9757,9765,9764,9763,9759,9760,9762,9761,9758,9758,9759,9762,9761,9760,9759,9762,9758,9761,9760,9762,9759,9760,9758,9761,9761,9759,9760,9758,9762,9757,9765,9756,9764,9763,9765,9757,9763,9756,9764,9764,9757,9763,9756,9765,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,9780,9801,9803,9802,9801,9803,9802,9802,9801,9803,9804,9806,9805,9806,9804,9805,9804,9805,9806,10038,10040,10039,10037,10039,10040,10037,10038,10040,10038,10037,10039,10038,10037,10040,10039,9473,9462,9474,9461,10117,10238,10240,10239,10240,10238,10239,10238,10239,10240,10241,10243,10242,10243,10241,10242,10241,10242,10243)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |