SELECT
cscart_images.*,
cscart_images_links.*,
cscart_common_descriptions.description AS alt,
cscart_images.image_id AS images_image_id
FROM
cscart_images_links
LEFT JOIN cscart_images ON cscart_images_links.detailed_id = cscart_images.image_id
LEFT JOIN cscart_common_descriptions ON cscart_common_descriptions.object_id = cscart_images.image_id
AND cscart_common_descriptions.object_holder = 'images'
AND cscart_common_descriptions.lang_code = 'en'
WHERE
cscart_images_links.object_type = 'variant_image'
AND cscart_images_links.type = 'V'
AND cscart_images_links.object_id IN (
84392,
84393,
84394,
84395,
84396,
84397,
84398,
84399,
84400,
84401,
84402,
84403,
84404,
84405,
84406,
84407,
84472,
84473,
84570,
84571,
84636,
84637,
84672,
84673,
84674,
84675,
84676,
84677,
84680,
84681,
84706,
84707,
84708,
84709,
84710,
84711,
84712,
84713,
84736,
84737,
84738,
84739,
84740,
84741,
84742,
84743,
84800,
84801,
84804,
84805,
84810,
84811,
84812,
84813,
84814,
84815,
84820,
84821,
84854,
84855,
84880,
84881,
84882,
84883,
84884,
84885,
84890,
84891,
84900,
84901,
84934,
84935,
84936,
84937,
84938,
84939,
85178,
85179,
85196,
85197,
85202,
85203,
85208,
85209,
85210,
85211,
85212,
85213,
85248,
85249,
85832,
85833,
85834,
85835,
85836,
85837,
85838,
85839,
85840,
85841,
85842,
85843,
85844,
85845,
85846,
85847,
85848,
85849,
85850,
85851,
85852,
85853,
85854,
85855,
85856,
85857,
85858,
85859,
85860,
85861,
85862,
85863,
85864,
85865,
85866,
85867,
85868,
85869,
85870,
85871,
85872,
85873,
85874,
85875,
85876,
85877,
85878,
85879,
132368,
132369,
132370,
132371,
132372,
132373,
132374,
132375,
171598,
171599,
171600,
171601,
171602,
171603,
171604,
171605,
171606,
171607,
171608,
171609,
171610,
171611
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id