| 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 (535,539,540,538,537,8803,536,540,536,539,8803,538,537,540,536,539,8803,537,538,540,536,538,8803,537,539,539,538,536,8803,537,540,545,9856,544,9855,543,9854,542,10080,541,8804,545,9856,544,9855,543,9854,541,10080,542,8804,545,9856,544,9855,542,9854,541,10080,543,8804,545,9856,9855,543,542,9854,541,10080,544,8804,9856,544,9855,543,542,9854,541,10080,545,8804,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,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,2923,2922,2922,2923,2932,2931,2932,2931,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,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,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,3485,3491,3490,3484,3483,3489,3486,3482,3488,3487,3481,3485,3491,3486,3484,3490,3483,3489,3488,3487,3481,3482,3485,3486,3491,3484,3490,3489,3488,3482,3487,3481,3483,3485,3486,3491,3490,3489,3483,3488,3482,3487,3481,3484,3484,3483,3482,3481,3491,3485,3490,3489,3488,3487,3486,3485,3484,3491,3483,3490,3489,3482,3488,3481,3487,3486,3491,3485,3490,3489,3484,3488,3483,3482,3486,3481,3487,3491,3485,3490,3489,3484,3483,3487,3482,3481,3486,3488,3491,3485,3490,3484,3488,3483,3482,3487,3481,3486,3489,3491,3485,3489,3484,3488,3483,3482,3487,3481,3486,3490,3490,3485,3489,3488,3487,3484,3483,3486,3482,3481,3491,3493,3494,3496,3495,3492,3492,3493,3496,3495,3494,3493,3496,3492,3495,3494,3496,3493,3494,3492,3495,3495,3493,3494,3492,3496,3497,3498,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,3507,3508,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,3532,3534,3533,3534,3532,3533,3532,3533,3534,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,3544,3549,3543,3548,3545,3542,3547,3546,3541,3544,3545,3549,3543,3548,3547,3546,3541,3542,3544,3545,3549,3548,3547,3542,3546,3541,3543,3543,3542,3541,3549,3544,3548,3547,3546,3545,3544,3543,3549,3542,3548,3547,3541,3546,3545,3549,3544,3548,3547,3543,3542,3545,3541,3546,3549,3544,3548,3543,3546,3542,3541,3545,3547,3549,3544,3547,3543,3546,3542,3541,3545,3548,3548,3544,3547,3546,3543,3545,3542,3541,3549,3550,3552,3551,3552,3550,3551,3550,3551,3552,3553,3889,3888,3884,3885,3883,3887,3886,3882,3889,3884,3888,3887,3885,3886,3882,3883,3888,3889,3887,3885,3886,3883,3882,3884,3889,3884,3888,3883,3887,3882,3886,3885,3889,3888,3884,3887,3883,3882,3885,3886,3889,3888,3884,3886,3883,3882,3885,3887,3889,3884,3887,3883,3886,3882,3888,3885,3888,3884,3887,3886,3883,3882,3889,3885,3906,3907,3905,3904,3907,3906,3904,3905,3907,3904,3905,3906,3906,3904,3905,3907,3923,3924,3922,3921,3924,3921,3923,3922,3924,3921,3923,3922,3923,3921,3924,3922,9143,4033,5064,5090,7078,7079,7077,7076,7079,7076,7078,7077,7079,7076,7077,7078,7078,7076,7079,7077,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,7190,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,7996,8101,8205,3500,9717,3499,3506,9716,3505,9674,3504,9673,3503,9675,3502,9676,3501,8685,8687,540,536,539,538,537,8803,545,8804,544,543,542,541,2939,2944,2943,2938,2937,2941,2942,2940,8984,7171,7175,7170,7172,7174,7173,9107,4033,9143,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,545,8804,9854,544,543,542,541,545,543,544,542,541,9854,8804,9855,544,545,543,542,541,9855,9854,8804,9856,545,9856,9855,9854,8804,10080,544,543,541,542)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 9 |