1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

Денят в снимки

Днес се навършват 100 години от приемането на закон за правото на британските жени над 30 години да гласуват Още снимки »
Time: 0.073 sec
Memory: 4.51 Mb
Peak memory: 4.80 Mb
Total SQL queries: 35
Total SQL time: 0.029 sec
Slowest SQL query time: 0.005 sec
Slowest SQL query:
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