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 = 'product'
AND cscart_images_links.type = 'A'
AND cscart_images_links.object_id IN (
68974, 68973, 68972, 68971, 68970, 68969,
68968, 68967, 68966, 68965, 68964,
68963, 68962, 68961, 68960, 68959,
68958, 68957, 68956, 68955, 68954,
68953, 68952, 68951, 68950, 68949,
68948, 68947, 68946, 68945, 68321,
68290, 68289, 68288, 68286, 68285,
68284, 68283, 68282, 68281
)
ORDER BY
cscart_images_links.position,
cscart_images_links.pair_id