SELECT * FROM `pages`
LEFT JOIN `pages_lang` ON (`pages`.`page_id` = `pages_lang`.`page_id`)
WHERE `pages`.`page_id` = '6'
AND `pages_lang`.`page_id` = '6'
AND `lang_id` = '1' LIMIT 1
SELECT * FROM `pages`
LEFT JOIN `pages_lang` ON (`pages`.`page_id` = `pages_lang`.`page_id`)
WHERE `pages`.`page_id` = '83'
AND `pages_lang`.`page_id` = '83'
AND `lang_id` = '1' LIMIT 1