| 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 (3226,3227,3229,3228,3225,3225,3226,3229,3228,3227,3226,3229,3225,3228,3227,3229,3226,3227,3225,3228,3228,3226,3227,3225,3229,3752,3753,3755,3754,3751,3751,3752,3755,3754,3753,3752,3755,3751,3754,3753,3755,3752,3753,3751,3754,3754,3752,3753,3751,3755,3758,3757,3759,3761,3762,3760,3756,3758,3762,3759,3761,3760,3756,3757,3757,3756,3758,3761,3762,3760,3759,3758,3762,3757,3756,3760,3761,3759,3762,3758,3761,3757,3759,3756,3760,3762,3757,3756,3758,3760,3761,3759,3758,3761,3760,3759,3757,3756,3762,10043,3766,10042,3765,10041,3767,3764,3769,3768,3763,10043,3766,10042,3765,3767,10041,3769,3768,3763,3764,10043,3766,10042,3767,3769,10041,3764,3768,3763,3765,10043,3767,10042,3769,3768,10041,3765,3764,3763,3766,10043,3766,10042,3765,10041,3764,3769,3763,3768,3767,10043,3766,10042,3769,3765,10041,3764,3763,3767,3768,10043,3766,10042,3765,10041,3764,3768,3763,3767,3769,3775,3776,3781,3783,3773,3772,3780,3779,3774,3778,3771,3777,3770,3775,3774,3783,3781,3773,3780,3772,3779,3776,3778,3777,3770,3771,3775,3783,3776,3773,3781,3780,3774,3779,3778,3771,3770,3777,3772,3775,3783,3776,3781,3780,3774,3779,3772,3778,3771,3770,3777,3773,3775,3776,3783,3781,3780,3773,3779,3772,3778,3771,3777,3770,3774,3776,3774,3773,3783,3772,3771,3770,3780,3775,3781,3779,3778,3777,3774,3783,3781,3780,3779,3771,3778,3773,3772,3777,3776,3770,3775,3783,3781,3780,3774,3779,3773,3778,3772,3770,3771,3776,3777,3775,3775,3783,3781,3774,3773,3780,3772,3779,3771,3777,3770,3776,3778,3783,3781,3780,3774,3773,3772,3778,3771,3775,3777,3770,3776,3779,3783,3781,3774,3773,3779,3772,3778,3775,3777,3771,3770,3776,3780,3775,3774,3783,3780,3773,3779,3778,3772,3771,3777,3770,3776,3781,3781,3774,3780,3775,3779,3773,3778,3772,3777,3771,3776,3770,3783,10120,10121,3790,3789,3788,3787,3786,3785,3784,10120,10121,3790,3789,3788,3787,3786,3784,3785,10120,10121,3790,3789,3788,3787,3785,3784,3786,10120,10121,3790,3789,3788,3786,3785,3784,3787,10121,10120,3790,3789,3787,3786,3785,3784,3788,10120,10121,3790,3788,3787,3786,3785,3784,3789,10120,10121,3789,3788,3787,3786,3785,3784,3790,3793,3794,3792,3791,3794,3793,3791,3792,3794,3791,3793,3792,3793,3791,3792,3794,3818,3817,3813,3814,3812,3816,3815,3811,3818,3813,3817,3816,3814,3815,3811,3812,3817,3818,3816,3814,3815,3812,3811,3813,3818,3813,3812,3817,3816,3811,3815,3814,3818,3817,3813,3816,3812,3811,3815,3814,3818,3817,3813,3812,3815,3811,3816,3814,3818,3813,3816,3812,3815,3811,3814,3817,3817,3813,3816,3815,3812,3811,3814,3818,3823,3824,3822,3821,8710,3820,3824,3820,3823,8710,3822,3821,3824,3820,3823,8710,3822,3821,3824,3820,3822,8710,3823,3821,3823,3820,3822,8710,3824,3821,3826,3825,3825,3826,3829,3830,3832,3831,3828,3828,3829,3832,3831,3830,3829,3832,3828,3831,3830,3832,3829,3830,3828,3831,3831,3829,3830,3828,3832,10091,10090,3837,10094,3836,10088,3846,3835,3834,3844,3841,3843,3842,10092,10093,10091,10090,3840,3837,3839,9887,3838,10094,3836,10088,3835,3846,3841,3845,3844,3833,3843,10092,3842,10093,3834,10091,10090,3840,3837,3839,9887,3838,10094,10088,3836,3846,3841,3844,3845,3834,3833,3843,10092,3842,10093,3835,10091,10090,3840,3837,3839,9887,3838,10094,3841,10088,3846,3835,3834,3845,3844,3833,3843,10092,3842,10093,3836,10091,10090,3840,3841,3839,9887,10088,10094,3838,3846,3836,3835,3844,3834,3845,3833,3843,3842,10092,10093,3837,10091,10090,3841,10088,10094,3837,3846,3836,3844,3835,3843,3834,3842,10092,10093,10091,10090,3841,10088,10094,3846,3837,3836,3835,3844,3843,3834,3842,10092,10093,3837,3836,3835,3834,10092,10093,10091,3846,3844,3841,10088,3843,3842,10090,10094,3840,3839,3838,3837,10091,10090,3836,9887,3835,10088,3846,10094,3834,3833,3845,3844,3843,3842,10092,10093,3841,10091,3840,10090,3839,3838,9887,10088,10094,3837,3846,3836,3835,3845,3844,3834,3833,3843,10092,10093,3841,3842,10091,3840,10090,3839,3838,9887,10094,10088,3837,3846,3836,3835,3834,3845,3844,3833,10092,3842,3841,10093,3843,10091,3840,10090,3839,3838,9887,10094,3837,10088,3846,3836,3835,3834,3845,3833,3843,3842,10092,3841,10093,3844,10091,10090,10094,10088,3837,3846,3836,3835,3834,3844,3843,10092,3842,3841,10093,3840,10091,10090,3839,3838,9887,10088,10094,3837,3836,3845,3835,3844,3843,3834,3833,3842,10092,3841,10093,3846,3848,3847,3848,3847,3849,3855,3861,3860,3852,3854,3859,3853,3858,3851,3857,9011,3856,3850,3854,3861,3853,3860,3855,3852,3859,3858,3857,3850,3856,9011,3851,3855,3861,3860,3854,3853,3859,3851,3857,3858,3850,9011,3856,3852,3855,3861,3854,3860,3859,3852,3858,3857,3851,3850,3856,9011,3853,3853,3861,3852,3851,3850,9011,3854,3860,3859,3858,3857,3856,3855,3854,3853,3851,3860,3861,3859,3858,3852,3857,3850,3856,3855,9011,3860,3854,3861,3859,3853,3852,3858,3857,3851,3850,9011,3855,3856,3861,3854,3853,3860,3859,3852,3851,3858,3850,3856,9011,3855,3857,3854,3860,3861,3859,3853,3852,3857,3850,3851,9011,3856,3855,3858,3860,3854,3861,3852,3853,3858,3851,3857,3850,9011,3856,3855,3859,3854,3861,3852,3859,3853,3858,3851,3850,3857,3856,9011,3855,3860,3853,3854,3852,3860,3859,3851,3858,3857,3850,9011,3856,3855,3861,3865,3866,3869,3864,3868,3867,3863,3865,3866,3869,3868,3867,3863,3864,3864,3863,3869,3865,3868,3867,3866,3865,3869,3864,3868,3863,3867,3866,3869,3865,3868,3864,3866,3863,3867,3869,3865,3867,3864,3863,3866,3868,3868,3865,3867,3866,3864,3863,3869,3894,3895,3893,3892,3895,3894,3892,3893,3895,3892,3893,3894,3894,3892,3893,3895,3903,3902,3898,3899,3897,3901,3900,3896,3903,3898,3902,3901,3899,3900,3896,3897,3902,3903,3901,3899,3900,3897,3896,3898,3903,3898,3902,3897,3901,3896,3900,3899,3903,3902,3898,3901,3897,3896,3899,3900,3903,3902,3898,3900,3897,3896,3901,3899,3903,3898,3901,3897,3900,3896,3902,3899,3902,3898,3901,3900,3897,3896,3903,3899,3917,3918,3920,3919,3916,3916,3917,3920,3919,3918,3917,3920,3916,3919,3918,3920,3917,3918,3916,3919,3919,3917,3918,3916,3920,5099,3824,3820,3823,3822,3821,8710,8711,3855,3861,3854,3860,3853,3859,3852,3858,3857,3851,3850,3856,9011,10091,10090,3837,10088,10094,3846,3836,3835,3844,3843,3834,3842,3841,10092,10093,9887,10032,10033,10034,10035,10031,10031,10032,10034,10035,10033,10032,10034,10031,10035,10033,10035,10032,10033,10031,10034,10032,10034,10033,10031,10035,10043,3766,10042,3767,3765,3764,3769,3763,3768,10041,10043,3766,10041,3765,3767,3769,3764,3763,3768,10042,10042,3766,10041,3767,3769,3765,3768,3764,3763,10043,10049,10045,10046,10048,10047,10044,10048,10049,10047,10046,10044,10045,10049,10045,10048,10044,10047,10046,10049,10048,10045,10044,10047,10046,10049,10045,10047,10044,10046,10048,10048,10047,10045,10044,10046,10049,10051,10052,10063,10053,10050,10050,10051,10063,10053,10052,10051,10063,10050,10053,10052,10063,10051,10052,10050,10053,10056,10057,10055,10054,10057,10054,10056,10055,10057,10054,10055,10056,10056,10054,10057,10055,10053,10051,10052,10050,10063,10065,10066,10068,10067,10064,10064,10065,10068,10067,10066,10065,10068,10064,10067,10066,10068,10065,10066,10064,10067,10067,10065,10066,10064,10068,10120,10121,10120,10121,3790,3789,3788,3787,3786,3785,3784,10084,10085,10086,10084,10120,10121,3790,3789,3788,3787,3786,3785,3784,10085,10086,10120,10121,10085,10084,3790,3789,3788,3787,3786,3785,3784,10086,10091,3840,10090,3839,3838,9887,3837,10094,3846,3836,3835,3845,3844,3834,3843,3833,3842,10092,3841,10093,10088,10091,3840,3839,9887,3838,10094,10088,3837,3846,3836,3835,3845,3844,3834,3843,3833,3842,10092,3841,10093,10090,3840,10090,3839,9887,3838,10094,3837,10088,3836,3846,3835,3845,3834,3844,3833,3843,10092,3842,3841,10093,10091,10091,3841,3840,3839,10090,3838,9887,10094,3837,10088,3836,3835,3846,3845,3844,3834,3843,3833,3842,10093,10092,10091,3841,3840,10090,3839,3838,9887,10094,3837,10088,3836,3835,3846,3845,3834,3844,3843,3833,10092,3842,10093,10091,3840,10090,3839,3838,9887,3837,10088,3846,3836,3835,3845,3844,3834,3843,3833,3842,10092,3841,10093,10094,3788,10085,3787,10086,3786,10084,3785,10083,3784,3790,10121,3789,10120,3789,10120,3788,10085,3787,10086,3786,10084,3785,10083,3784,3790,10121)
GROUP BY `spvd`.`attribute_value_id`
ORDER BY `spvd`.`attribute_position` ASC
LIMIT 0, 1000 | 0.001 | 5 |