SELECT 
  cscart_images_links.*, 
  cscart_images.*, 
  cscart_common_descriptions.description AS alt 
FROM 
  cscart_images_links 
  LEFT JOIN cscart_images ON cscart_images.image_id = cscart_images_links.detailed_id 
  LEFT JOIN cscart_cp_review_images ON cscart_cp_review_images.post_image_id = cscart_images_links.pair_id 
  LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.post_id = cscart_images_links.object_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 = 'uk' 
WHERE 
  cscart_discussion_posts.thread_id IN (10167) 
  AND cscart_discussion_posts.status = 'A' 
  AND cscart_cp_review_images.status = 'A' 
  AND cscart_discussion_posts.cp_pr_user_delete = 'N' 
LIMIT 
  10