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 (
168964, 168965, 168966, 168967, 169142,
169143, 169154, 169155, 169156, 169157,
169158, 169159, 169160, 169161, 169170,
169171, 169614, 169615, 169624, 169625,
169626, 169627, 169912, 169913, 169916,
169917, 169918, 169919, 170076, 170077,
170800, 170801, 170954, 170955, 170956,
170957, 170974, 170975, 171496, 171497
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id