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 (
212170, 212171, 212172, 212173, 212174,
212175, 213368, 213369, 213370, 213371,
213372, 213373, 213374, 213375, 213376,
213377, 213378, 213379, 213380, 213381,
213382, 213383, 213384, 213385, 213386,
213387, 213388, 213389, 213390, 213391,
213392, 213393, 213394, 213395, 213396,
213397, 213398, 213399, 213400, 213401
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id