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 = 'de' 
WHERE 
  cscart_images_links.object_type = 'blog' 
  AND cscart_images_links.type = 'M' 
  AND cscart_images_links.object_id IN (
    145, 137, 138, 139, 136, 134, 133, 132, 
    130, 129, 127, 126, 125, 124, 122, 120, 
    119, 118, 116, 104, 103, 102, 80, 79, 
    78, 76, 60, 58
  ) 
ORDER BY 
  cscart_images_links.position, 
  cscart_images_links.pair_id