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 (
    52874, 52873, 52872, 52871, 52870, 52869, 
    52868, 52867, 52866, 52865, 52864, 
    52863, 52862, 52861, 52860, 52859, 
    52858, 52857, 52856, 52979, 52908, 
    52890, 52889, 52888, 52828, 52820, 
    52819, 53140, 53139, 52807, 52806, 
    52805, 52804, 53031, 53030, 52786, 
    52785, 52784, 53088, 52774, 52891, 
    52880, 52757, 52749, 52748, 52747, 
    52746, 52778, 52758, 52685, 52709, 
    52687, 52686, 52682, 52677, 52671, 
    52670, 52669, 52942, 52941, 52940, 
    52939, 52636, 52635, 52645, 52644, 
    52643, 52642, 52589, 52588, 52587, 
    52586, 52585, 59345, 52633, 52632, 
    52578, 52542, 52524, 52707
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id