| SELECT *
FROM (`shop_related_products`)
WHERE `product_id` IN (15,614,615,617,613,616,624,623,621,625,622,636,632,635,633,631,634,642,641,639,637,640,638,646,647,649,645,648,656,660,658,659,657,666,662,665,661,663,664,672,668,671,669,667,670,674,678,673,677,675,676,684,683,679,681,682,680,689,687,688,690,697,693,696,694,695,692,703,702,698,700,701,699,704,706,710,705,709,708,707,715,714,716,718,719,717,722,723,726,720,725,724,721,731,734,729,728,733,732,9950,727,730,740,736,739,737,738,735,741,742,746,744,743,745,752,749,751,748,750,753,754,762,763,766,760,765,764,761,767,768,769,771,772,774,773,770,779,776,778,775,777,780,786,782,785,783,784,781,8827,1276,1284,1287,3589,3592,3591,3590,4893,4889,4892,4890,4888,4891,4917,4921,4920,4919,4918,4955,4953,4954,4952,4973,4971,4970,4972,4981,4976,4980,4975,4979,4977,4974,4978,4984,4982,4983,4985,4986,4990,4989,4988,4987,4994,4991,4992,4993,4996,5000,4998,4995,4997,4999,5016,5017,5019,5015,5018,5024,5020,5022,5023,5021,5028,5032,5031,5027,5029,5026,5030,5472,5471,5473,7023,7024,7021,7025,7022,7830,7828,7829,7827,7831,8077,8122,8272,8331,8338,8339,8340,8521,8522,8523,8524,8525,8526,8527,8530,8533,8534,8535,8536,8538,8539,8548,8549,8826,8828,8831,8832,8833,8834,8837,8835,8836,9138,9187,9186,9184,9183,9185,9188,9498,9522,9521,9497,9519,9520,9496,9505,9500,9504,9499,9502,9503,9501,9511,9507,9510,9508,9509,9506,9514,9515,9518,9512,9517,9516,9513,9536,9535,9537,9538,9534,9941,9942,9944,9988,9984,9987,9985,9986,9983) | 0.002 | 1570 |
| 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 (15,614,615,617,616,613,613,614,617,616,615,614,617,613,616,615,617,614,615,613,616,616,614,615,613,617,622,623,625,624,621,621,622,625,624,623,622,625,621,624,623,625,622,623,621,624,624,622,623,621,625,636,632,633,635,634,631,635,636,634,633,631,632,636,632,635,631,634,633,636,635,632,631,634,633,636,632,634,631,635,633,635,632,634,631,633,636,642,638,639,641,640,637,641,642,640,639,637,638,642,638,641,637,640,639,642,641,638,637,639,640,642,638,640,637,641,639,641,640,638,637,639,642,646,647,649,648,645,645,646,649,648,647,646,649,645,648,647,649,646,647,645,648,648,646,647,645,649,657,658,660,659,656,656,657,660,659,658,657,660,656,659,658,660,657,658,656,659,659,657,658,656,660,666,662,663,665,664,661,665,666,664,663,661,662,666,662,665,661,664,663,666,665,662,661,664,663,666,662,664,661,665,663,665,662,664,661,666,663,672,668,669,671,670,667,671,672,670,669,667,668,672,668,671,667,670,669,672,671,668,667,670,669,672,668,670,667,671,669,671,668,670,667,672,669,678,674,675,677,676,673,677,678,676,675,673,674,678,674,677,673,676,675,678,677,674,673,676,675,678,674,676,673,677,675,677,676,674,673,675,678,684,680,681,683,682,679,683,684,682,681,679,680,684,680,683,679,682,681,684,683,680,679,681,682,684,680,682,679,681,683,683,680,682,679,684,681,689,690,688,687,690,689,687,688,690,687,689,688,689,687,688,690,697,693,694,696,695,692,696,697,695,694,692,693,697,693,696,692,695,694,697,696,693,692,695,694,697,693,695,692,696,694,696,693,695,692,697,694,703,699,700,702,701,698,702,703,701,700,698,699,703,699,702,698,701,700,703,702,699,698,700,701,703,699,701,698,700,702,702,701,699,698,700,703,704,710,706,707,709,708,705,709,710,708,707,705,706,710,706,709,705,708,707,710,709,706,705,707,708,710,706,708,705,709,707,709,708,706,707,705,710,714,716,715,716,714,715,714,715,716,717,719,718,717,719,718,718,717,719,722,723,726,721,725,724,720,722,723,726,725,724,720,721,721,720,726,722,725,724,723,722,726,721,725,720,724,723,726,722,725,721,723,720,724,726,722,724,721,720,723,725,725,722,724,723,721,720,726,730,9950,729,734,731,728,733,732,727,730,9950,731,729,734,733,732,727,728,730,9950,731,734,733,728,732,727,729,729,728,9950,727,730,734,733,732,731,730,729,728,9950,734,733,727,732,731,730,9950,734,733,729,728,731,727,732,730,734,9950,729,732,728,727,731,733,730,9950,733,729,732,728,727,731,734,740,736,737,739,738,735,739,740,738,737,735,736,740,736,739,735,738,737,740,739,736,735,737,738,740,736,738,735,739,737,739,738,736,735,737,740,741,742,745,746,744,743,746,745,743,744,746,743,744,745,745,743,746,744,753,749,750,752,751,748,752,753,751,750,748,749,753,749,752,748,751,750,753,752,749,748,751,750,753,749,751,748,752,750,752,751,749,748,753,750,754,762,763,766,761,765,764,760,762,763,766,765,764,760,761,761,760,766,762,765,764,763,762,766,761,765,760,764,763,766,762,765,761,763,760,764,766,762,764,761,760,763,765,765,764,762,763,761,760,766,767,768,769,771,772,774,773,770,770,771,774,773,772,771,774,770,773,772,774,771,772,770,773,773,771,772,770,774,780,776,777,779,778,775,779,780,778,777,775,776,780,776,779,775,778,777,780,779,776,775,777,778,780,776,778,775,777,779,779,778,776,775,780,777,786,782,783,785,784,781,785,786,784,783,781,782,786,782,785,781,784,783,786,785,782,781,783,784,786,782,784,781,783,785,785,782,784,781,786,783,8827,1276,1284,1287,3589,3590,3592,3591,3592,3590,3591,3591,3590,3592,4893,4889,4890,4892,4891,4888,4892,4893,4891,4890,4888,4889,4893,4889,4892,4888,4891,4890,4893,4892,4889,4888,4891,4890,4893,4889,4891,4888,4890,4892,4892,4889,4891,4888,4890,4893,4918,4919,4921,4920,4917,4917,4918,4921,4920,4919,4918,4921,4917,4920,4919,4921,4918,4919,4917,4920,4920,4918,4919,4917,4921,4954,4955,4953,4952,4955,4954,4952,4953,4955,4952,4953,4954,4954,4952,4953,4955,4972,4973,4971,4970,4973,4970,4972,4971,4973,4970,4972,4971,4972,4970,4971,4973,4981,4980,4976,4977,4975,4979,4978,4974,4981,4976,4980,4979,4977,4978,4974,4975,4980,4981,4979,4977,4978,4975,4974,4976,4981,4976,4975,4980,4979,4974,4978,4977,4981,4980,4976,4979,4975,4974,4977,4978,4981,4980,4976,4975,4978,4974,4979,4977,4981,4976,4979,4975,4978,4974,4977,4980,4980,4979,4976,4978,4975,4974,4977,4981,4984,4985,4983,4982,4985,4982,4984,4983,4985,4982,4984,4983,4984,4982,4985,4983,4987,4988,4990,4989,4986,4986,4987,4990,4989,4988,4987,4990,4986,4989,4988,4990,4987,4988,4986,4989,4989,4987,4988,4986,4990,4993,4994,4992,4991,4994,4993,4991,4992,4994,4991,4993,4992,4993,4991,4992,4994,5000,4996,4997,4999,4998,4995,4999,5000,4998,4997,4995,4996,5000,4996,4999,4995,4998,4997,5000,4999,4996,4995,4998,4997,5000,4996,4998,4995,4997,4999,4999,4996,4998,4995,4997,5000,5016,5017,5019,5018,5015,5015,5016,5019,5018,5017,5016,5019,5015,5018,5017,5019,5016,5017,5015,5018,5018,5016,5017,5015,5019,5021,5022,5024,5023,5020,5020,5021,5024,5023,5022,5021,5024,5020,5023,5022,5024,5021,5022,5020,5023,5023,5021,5022,5020,5024,5028,5029,5032,5027,5031,5030,5026,5028,5029,5032,5031,5030,5026,5027,5027,5026,5032,5028,5031,5030,5029,5028,5032,5027,5031,5026,5030,5029,5032,5028,5031,5027,5029,5026,5030,5032,5028,5030,5027,5026,5029,5031,5031,5028,5030,5029,5027,5026,5032,5471,5473,5472,5473,5471,5472,5471,5472,5473,7022,7023,7025,7024,7021,7021,7022,7025,7024,7023,7022,7025,7021,7024,7023,7025,7022,7023,7021,7024,7024,7022,7023,7021,7025,7829,7830,7828,7827,7830,7827,7829,7828,7830,7827,7828,7829,7829,7827,7830,7828,7831,8077,8122,8272,8331,8338,8339,8340,8521,8522,8523,8524,8525,8526,8527,8530,8533,8534,8535,8536,8538,8539,8548,8549,8826,1276,8827,8828,8831,8832,8833,8834,8835,8837,8836,8837,8835,8836,8835,8837,8836,9138,9188,9184,9185,9187,9186,9183,9187,9188,9186,9185,9183,9184,9188,9184,9187,9183,9186,9185,9188,9187,9184,9183,9185,9186,9188,9184,9186,9183,9187,9185,9187,9184,9186,9183,9188,9185,9498,9519,9522,9497,9521,9520,9496,9498,9519,9522,9521,9520,9496,9497,9497,9496,9522,9498,9521,9520,9519,9501,9502,9505,9500,9504,9503,9499,9501,9502,9505,9504,9503,9499,9500,9500,9499,9505,9501,9504,9503,9502,9501,9505,9500,9504,9499,9503,9502,9505,9501,9504,9500,9502,9499,9503,9505,9501,9503,9500,9499,9502,9504,9504,9501,9503,9502,9500,9499,9505,9511,9507,9508,9510,9509,9506,9510,9511,9509,9508,9506,9507,9511,9507,9510,9506,9509,9508,9511,9510,9507,9506,9508,9509,9511,9507,9509,9506,9508,9510,9510,9507,9509,9506,9508,9511,9514,9515,9518,9513,9517,9516,9512,9514,9515,9518,9517,9516,9512,9513,9513,9512,9518,9514,9517,9516,9515,9514,9518,9513,9517,9512,9516,9515,9518,9514,9517,9513,9515,9512,9516,9518,9514,9516,9513,9512,9515,9517,9517,9514,9516,9515,9513,9512,9518,9498,9522,9497,9521,9496,9520,9519,9522,9498,9521,9497,9519,9496,9520,9522,9498,9497,9520,9496,9519,9521,9521,9498,9520,9519,9497,9496,9522,9537,9534,9538,9536,9535,9534,9538,9536,9535,9537,9538,9534,9537,9535,9536,9535,9538,9534,9536,9537,9536,9534,9535,9537,9538,9942,9941,9941,9942,9944,734,729,733,728,732,730,731,727,9950,9988,9984,9985,9987,9986,9983,9987,9988,9986,9985,9983,9984,9988,9984,9987,9983,9986,9985,9988,9987,9984,9983,9986,9985,9988,9984,9986,9983,9985,9987,9987,9984,9986,9983,9988,9985)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 0 |