Photographic Management and Production

SELECT `nj_channels`.*, 'it' AS `lang`, `t_title`.`value` AS `title`, `t_text`.`value` AS `text` FROM `nj_channels` LEFT JOIN `nj_lang_strings` AS `t_title` ON `t_title`.`id` = `nj_channels`.`title_id` AND `t_title`.`lang` = 'it' LEFT JOIN `nj_lang_text` AS `t_text` ON `t_text`.`id` = `nj_channels`.`text_id` AND `t_text`.`lang` = 'it' WHERE (name = ) ORDER BY `nj_channels`.`ord` ASC, `created_on` DESC