SELECT `nj_subject`.*, 'it' AS `lang`, `cat_lang`.`value` AS `category`, `nj_lang_strings`.`value` AS `title`, `nj_lang_text`.`value` AS `text` FROM `nj_subject` LEFT JOIN `nj_tree_nested` AS `cat` ON cat.id = category_id LEFT JOIN `nj_lang_strings` AS `cat_lang` ON cat_lang.id = cat.title_id AND cat_lang.lang = 'it' LEFT JOIN `nj_lang_strings` ON `nj_lang_strings`.`id` = `nj_subject`.`title_id` AND `nj_lang_strings`.`lang` = 'it' LEFT JOIN `nj_lang_text` ON `nj_lang_text`.`id` = `nj_subject`.`text_id` AND `nj_lang_text`.`lang` = 'it' WHERE (content = ?) AND (channel_id = '2') AND (type_id = 5) ORDER BY `created_on` DESC