SELECT `news`.*, `newscontent`.* FROM `news` INNER JOIN `newscontent` ON `newscontent`.`newscontent_newsid` = `news`.`news_id` WHERE `newscontent`.`newscontent_lang` = 'En' AND `news`.`news_id` = 5 ORDER BY `news`.`news_id`
tyrtyrtryr