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.image_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 (
    22807, 22808, 22809, 23288, 23289, 24187, 
    24184, 24185, 24186, 24188, 24189, 
    24190, 24191, 22801, 22802, 22803, 
    22804, 22805, 22806, 23234, 23233, 
    23235, 23236, 23237, 23238, 23255, 
    23256, 23251, 23252, 23284, 23285, 
    23286, 23287, 23208, 23209, 23210, 
    23211, 23212, 23213, 23214, 23215, 
    23216, 23217, 23218, 23219, 23220, 
    23221, 23222, 23223, 23224, 23225, 
    23226, 23227, 23228, 23229, 23230, 
    23231, 23232, 23257, 23258, 23259, 
    23260, 23261, 23262, 23263, 23264, 
    23265, 23266, 23267, 23268, 23269, 
    23270, 23271, 23272, 23273, 23274, 
    23275, 23276, 23277, 23278, 23279, 
    23280, 23281
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id