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 (
    41546, 41545, 41544, 41543, 41429, 41268, 
    41267, 41361, 41572, 41571, 41246, 
    41245, 41244, 41243, 41242, 41220, 
    41218, 41173, 41167, 41644, 41643, 
    41642, 41641, 41640, 41639, 41159, 
    41154, 41128, 41117, 41116, 41113, 
    41146, 41145, 41211, 41213, 41192, 
    41058, 41054, 41053, 41103, 41017, 
    40942, 40941, 40940, 40934, 40933, 
    40932, 40931, 40930, 40929, 40928, 
    40927, 40926, 40925, 40923, 40922, 
    40921, 40920, 40919, 40918, 40917, 
    40916, 40915, 40914, 40913, 40912, 
    40911, 40910, 40909, 40908, 40907, 
    40906, 40905, 40904, 40903, 40902, 
    40901, 40900, 40899, 41623
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id