SELECT
cscart_images_links.*,
cscart_images.image_path,
cscart_common_descriptions.description AS alt,
cscart_images.image_x,
cscart_images.image_y,
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 = 'fr'
WHERE
cscart_images_links.object_type = 'variant_image'
AND cscart_images_links.type = 'V'
AND cscart_images_links.object_id IN (
22321, 22320, 22319, 22318, 22317, 22316,
22315, 22314, 22322, 22323, 22324,
22325, 22326, 22327, 22328, 22329,
22330, 22331, 22334, 22344, 22354,
22332, 22333, 22335, 22338, 22339,
22340, 22343, 22345, 22349
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id