SELECT m.*, mm.*, (SELECT visible FROM bn_sections_meta WHERE section_id = mm.open_page AND language_id=2) as open_visible_page, IF (mm.open_url IS NOT NULL,1,0) as external FROM bn_navigation m LEFT JOIN bn_navigation_meta mm ON mm.menu_id= m.menu_id LEFT JOIN bn_sections s ON s.section_id = mm.open_page WHERE m.menu_id=16 AND mm.language_id = 2