SELECT 
  cscart_cp_pr_video_links.* 
FROM 
  cscart_cp_pr_video_links 
  LEFT JOIN cscart_discussion_posts ON cscart_discussion_posts.post_id = cscart_cp_pr_video_links.post_id 
WHERE 
  cscart_discussion_posts.thread_id IN (9006) 
  AND cscart_cp_pr_video_links.status = 'A' 
  AND cscart_discussion_posts.status = 'A' 
  AND cscart_discussion_posts.cp_pr_user_delete = 'N'