| 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 (8979,2888,2891,2890,2889,2888,2891,8979,2890,2889,2891,2888,2889,8979,2890,2890,2888,8979,2889,2891,2893,2897,2894,2896,2895,8980,2892,2892,2897,8980,2893,2896,2895,2894,2893,2897,2892,2896,8980,2895,2894,2893,2897,2896,2892,8980,2894,2895,2893,2897,2895,2892,2894,8980,2896,2892,2896,2893,2895,8980,2894,2897,8981,2898,2901,2900,2899,2898,2901,8981,2900,2899,2901,2898,2899,8981,2900,2900,2898,8981,2899,2901,2904,8982,2903,2902,2904,8982,2902,2903,8982,2903,2902,2904,2907,8983,2906,2905,2907,8983,2905,2906,2906,8983,2905,2907,3287,3286,3286,3287,3289,3291,8991,3290,3288,3291,8991,3289,3290,3288,3288,3291,8991,3289,3290,3288,3290,8991,3289,3291,8992,3292,3295,3294,3293,3292,3295,8992,3294,3293,3295,3292,8992,3293,3294,3294,3292,8992,3295,3293,3327,3329,3328,3327,3329,3328,3328,3327,3329,3331,3330,3330,3331,9233,9237,9232,9236,10016,9235,9234,3382,3452,3453,3456,3455,3454,9004,3451,3451,9004,3452,3456,3455,3454,3453,3452,3456,3451,3455,9004,3454,3453,3456,3452,3455,3451,9004,3453,3454,3456,3452,3454,3451,3453,9004,3455,3455,3452,3454,3451,9004,3453,3456,3458,3459,3461,3460,3457,3457,3458,3461,3460,3459,3458,3461,3457,3460,3459,3461,3458,3459,3457,3460,3460,3458,3459,3457,3461,5841,9296,5840,9295,5839,9294,5838,5841,9296,5840,9295,5838,9294,5839,5839,9296,9295,5838,9294,5841,5840,5840,9296,5839,5838,5841,9295,9294,9297,9300,5844,9299,5843,9298,5842,9297,9300,5844,9299,9298,5842,5843,9297,9300,5843,9299,5842,9298,5844,5847,5848,5851,5846,5850,5849,5845,5847,5848,5851,5850,5849,5845,5846,5846,5845,5851,5847,5850,5849,5848,5847,5851,5846,5850,5845,5849,5848,5851,5847,5850,5846,5848,5845,5849,5851,5847,5846,5849,5845,5848,5850,5850,5847,5849,5848,5846,5845,5851,5853,5854,5857,5856,5855,9044,5852,5852,9044,5853,5856,5857,5855,5854,5853,5852,5857,9044,5856,5854,5855,5857,5856,5852,5853,5854,9044,5855,5857,5853,5855,5852,5854,9044,5856,5856,5853,5855,5852,5854,9044,5857,5859,5860,5863,5862,5861,9045,5858,5858,9045,5859,5863,5862,5861,5860,5859,5863,5858,5862,9045,5861,5860,5863,5859,5862,5858,9045,5860,5861,5863,5859,5861,5858,5860,9045,5862,5862,5859,5861,5858,5860,9045,5863,9046,5864,5867,5866,5865,5864,5867,9046,5866,5865,5864,5867,9046,5865,5866,5866,5864,5865,9046,5867,5869,5870,5868,5870,5868,5869,5868,5869,5870,6251,6252,9071,6257,6258,6256,6255,9072,6254,6258,6254,9072,6257,6256,6255,6258,6254,9072,6257,6255,6256,6258,6254,6256,9072,6255,6257,6257,6256,6254,6255,9072,6258,6261,9073,6260,6259,6261,9073,6259,6260,6260,9073,6259,6261,6294,6287,6293,6292,6286,6285,6288,6291,6290,6289,9076,6284,6294,6287,6293,6286,6288,6292,6291,6290,6284,6289,9076,6285,6294,6287,6292,6293,6291,6288,6285,6290,6284,6289,9076,6286,6293,6294,6292,6288,6291,6290,6286,6289,6285,6284,9076,6287,6287,6294,6286,6293,6285,6292,6291,6284,6290,9076,6289,6288,6294,6293,6287,6292,6286,6291,6285,6284,6290,9076,6288,6289,6294,6293,6287,6292,6286,6291,6285,6284,9076,6289,6290,6288,6294,6293,6287,6292,6286,6285,6290,6284,6289,6288,9076,6291,6294,6287,6293,6286,6291,6285,6290,6284,6289,9076,6288,6292,6294,6287,6292,6291,6286,6290,6285,6284,6289,9076,6293,6288,6293,6287,6292,6291,6286,6290,6285,6289,6284,9076,6294,6288,6298,6304,6297,6303,6296,6302,6299,6301,6300,9077,6295,6298,6299,6304,6297,6303,6302,6301,6295,6300,9077,6296,6298,6299,6304,6303,6302,6296,6301,6295,6300,9077,6297,6297,6296,6295,9077,6298,6304,6303,6302,6301,6300,6299,6298,6297,6304,6296,6303,6302,6295,6301,9077,6300,6299,6304,6298,6303,6297,6302,6301,6296,6295,9077,6299,6300,6304,6298,6303,6302,6297,6296,6300,6295,9077,6299,6301,6304,6298,6303,6297,6301,6296,6295,6300,9077,6299,6302,6304,6298,6302,6297,6296,6301,6295,6300,9077,6299,6303,6303,6298,6302,6301,6300,6297,6296,6295,9077,6299,6304,6305,6307,6306,6305,6307,6306,6306,6305,6307,6605,6606,6609,6608,6607,9083,6604,6604,9083,6605,6609,6608,6607,6606,6605,6609,6604,6608,9083,6607,6606,6609,6605,6608,6604,9083,6606,6607,6609,6605,6607,6604,6606,9083,6608,6608,6605,6607,6604,6606,9083,6609,6611,6612,6615,6614,9084,6613,6610,6612,6610,6615,9084,6614,6611,6613,6615,6610,6614,9084,6613,6612,6611,6615,6614,6610,6611,6612,9084,6613,6615,6610,6611,6613,6612,9084,6614,6614,6610,6613,6611,6612,9084,6615,6619,6620,6618,6617,9085,6616,6620,6616,6619,9085,6618,6617,6620,6616,6619,9085,6618,6617,6620,6616,6618,9085,6617,6619,6619,6618,6616,9085,6620,6617,6623,6628,6624,6622,6627,6626,6625,9086,6621,6623,6624,6628,6627,6626,6621,6625,9086,6622,6622,6621,9086,6623,6628,6627,6626,6625,6624,6623,6622,6628,6627,6621,6626,9086,6625,6624,6628,6623,6627,6622,6626,6621,6624,9086,6625,6628,6623,6627,6622,6625,6621,6624,9086,6626,6628,6623,6626,6622,6625,6621,9086,6624,6627,6627,6623,6626,6625,6622,6621,9086,6624,6628,6632,6637,6636,6631,6635,6630,6634,9972,9087,6633,6629,6631,6632,6637,6636,6635,6629,6634,9972,9087,6633,6630,6630,6629,9972,9087,6637,6636,6635,6634,6631,6633,6632,6631,6630,6637,6636,6635,6629,9972,6634,9087,6632,6633,6637,6636,6630,6635,6629,9972,6634,9087,6633,6631,6632,6631,6637,6636,6630,6629,9972,6635,6633,6632,9087,6634,6637,6631,6636,6629,6630,6634,9972,6633,9087,6632,6635,6637,6631,6629,6635,6630,6634,9972,6633,9087,6632,6636,6636,6629,6635,6631,6634,6630,9972,9087,6633,6632,6637,6640,9721,6639,6644,6641,6643,6642,9088,6638,6641,9721,6640,6644,6643,6638,6642,9088,6639,6639,9721,6638,9088,6640,6644,6643,6642,6641,6640,6639,6644,9721,6638,6643,9088,6642,6641,6644,6640,9721,6639,6643,6638,6641,9088,6642,6640,6644,9721,6639,6642,6638,6641,9088,6643,6640,9721,6643,6639,6638,6642,9088,6641,6644,2888,2891,2889,2890,8979,2893,2897,2892,2894,2895,2896,8980,2898,2899,2901,2900,8981,2903,2902,2904,8982,2906,2907,2905,8983,3288,3289,3290,3291,8991,3292,3293,3295,3294,8992,3452,3456,3451,3453,3454,3455,9004,5853,5857,5852,5855,5854,5856,9044,5859,5863,5858,5860,5861,5862,9045,5864,5865,5867,5866,9046,9071,6252,9072,6258,6254,6257,6256,6255,6261,6260,6259,9073,6294,6287,6293,6286,6292,6285,6291,6284,6290,6289,6288,9076,6298,6304,6303,6297,6302,6296,6295,6299,6300,6301,9077,9083,6605,6609,6604,6607,6606,6608,9084,6615,6611,6610,6612,6614,6613,9085,6620,6616,6619,6618,6617,6623,6628,6622,6627,6621,6624,6625,6626,9086,6637,6631,6636,6630,6629,6635,9972,6634,6633,6632,9087,6640,6644,6639,6638,6641,6642,6643,9088,9236,9237,9234,9233,10016,9235,3382,9232,10016,9237,3382,9232,9236,9235,9234,9233,9237,9236,9232,10016,3382,9235,9234,9233,9237,9236,9232,9233,10016,3382,9234,9235,9237,9232,9235,10016,9234,3382,9233,9236,9236,9232,9235,9234,10016,3382,9237,9233,9296,5840,9295,5839,5838,5841,9294,9296,5840,5839,5838,9294,5841,9295,5840,5839,9295,9294,5841,5838,9296,9300,9299,5843,9298,9297,5842,5844,9300,5844,9299,5842,5843,9297,9298,9300,5844,5843,9298,5842,9297,9299,5844,5843,9299,5842,9298,9297,9300,6639,6644,6640,6638,6643,6642,6641,9088,9721,6637,6632,6631,6636,6630,6635,6634,6629,6633,9087,9972,9237,9236,9233,9232,3382,9235,10016,9234)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.002 | 15 |