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 (
    74051, 74050, 74049, 74048, 74047, 74046, 
    74045, 74044, 74043, 73817, 73816, 
    74713, 74712, 74711, 74710, 74709, 
    74708, 74707, 74706, 74705, 74704, 
    74703, 74702, 74701, 74700, 74699, 
    74698, 74697, 74696, 74695, 74694, 
    74466, 74601, 74540, 74092, 73927, 
    73907, 73906, 73824, 73952
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id