One news by id and lang_id

SELECT n.id
     , tnt.title
     , tntxt.text
     , n.status
     , n.date
FROM news n
LEFT JOIN translate_news_title tnt ON n.id = tnt.news_id AND tnt.lang_id = :LANG_ID
LEFT JOIN translate_news_text tntxt ON n.id = tntxt.news_id AND tntxt.lang_id = :LANG_ID
WHERE n.id = :NEWS_ID;