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 = 'M' 
  AND cscart_images_links.object_id IN (
    54608, 54607, 54606, 54605, 54604, 54603, 
    54602, 54601, 54600, 54599, 54598, 
    54597, 54596, 54595, 54594, 54593, 
    54592, 54591, 54590, 54589, 54588, 
    54587, 54586, 54441, 54366, 54365, 
    54263, 54262, 54261, 54204, 54140, 
    54135, 54132, 54208, 54371, 54370, 
    54368, 54110, 54082, 54081, 54080, 
    54079, 54056, 54053, 54052, 54647, 
    54646, 54645, 54644, 54643, 54642, 
    54641, 54640, 54639, 54638, 54324, 
    54278, 54277, 54276, 53951, 53945, 
    53932, 53915, 53914, 53913, 53912, 
    53911, 53910, 53909, 53908, 53901, 
    53897, 53896, 53895, 53887, 54447, 
    54446, 54445, 54444, 53790
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id