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 (
163974, 163975, 164058, 164059, 164086,
164087, 164088, 164089, 164090, 164091,
164234, 164235, 164236, 164237, 164258,
164259, 164630, 164631, 164632, 164633,
164720, 164721, 164722, 164723, 164724,
164725, 164726, 164727, 164728, 164729,
164730, 164731, 164732, 164733, 164734,
164735, 164736, 164737, 164738, 164739,
164848, 164849, 165210, 165211, 165216,
165217, 165242, 165243, 165244, 165245,
165306, 165307, 165308, 165309, 165312,
165313, 165314, 165315, 165316, 165317,
165318, 165319, 165588, 165589, 165590,
165591, 165592, 165593, 166114, 166115,
166116, 166117, 166118, 166119, 166120,
166121, 166122, 166123, 166124, 166125
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id