МЕДИЦИНСКИЯТ ТУРИЗЪМ В ЦЕНТРАЛНА И ИЗТОЧНА ЕВРОПА – ОГРОМЕН ПОТЕНЦИАЛ ЗА БЪРЗО РАЗВИТИЕ

SELECT 
					A.menu_id,
       				IF(B.menu_id IS NOT NULL,B.menu_id,0) AS parent,
       				A.menu_name,
       				A.menu_level as level,
       				(SELECT 
       					Label FROM bn_navigation_meta
       					WHERE menu_id=A.menu_id
       					AND language_id = 1) as label,
       				(SELECT 
       					menu_id
       						FROM bn_navigation WHERE 
       							menu_right = A.menu_left-1) as prev,
   					(SELECT 
       					menu_id
       						FROM bn_navigation WHERE 
       							menu_left = A.menu_right+1) as next,
       				M.*
				FROM bn_navigation AS A
				LEFT OUTER JOIN bn_navigation AS B
				ON B.menu_left = 
					(SELECT MAX(C.menu_left)
						FROM bn_navigation AS C
						WHERE A.menu_left > C.menu_left
						AND A.menu_left < C.menu_right)
				JOIN bn_navigation_meta M 
				ON M.menu_id = A.menu_id
				LEFT JOIN bn_articles_categories C
				ON C.category_id = M.open_category
				LEFT JOIN bn_sections S
				ON S.section_id = M.open_page
				WHERE A.menu_id IN (0,3,8,9,10,27,28,6,29,12,30,4,5,11,31,32,33,7,34,35,13,36,37)
				AND M.language_id = 1
				ORDER BY A.menu_left ASC