SELECT 
						m.*,
						mm.*,
						(SELECT 
							visible FROM bn_sections_meta
							WHERE section_id = mm.open_page
							AND language_id=1) 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=15
					AND mm.language_id = 1