GUITARREANDO VÝTVARKA TANEC DIVADLO HUDBA INFORMACE ZUŠ Guitarreando Statut soutěže Organizační řád Guitarreando 2010 Guitarreando 2009 Guitarreando 2008 Guitarreando 2007 Guitarreando 2006 Informace ZUŠ Úvodní strana Programy Inzeráty Noviny Střeziny Úřední deska Školní kluby Rozvrhy Informace o studiu Školné Přihláška ke studiu E-Omluvenka Výroční zprávy Historie Střeziny Propagační materiály Fotogalerie Zajímavé odkazy Jak k nám Kontakty Návštěvní kniha Střezina na Facebooku Puzzle :-) Partneři Úvodní strana GUITARREANDO GUITARREANDO NÁRODNÍ SOUTĚŽ V KOMORNÍ HŘE NA KYTARU XI. ročník 21.-22. května 2010 [Zpět] © 2010 ZUŠ, Hradec Králové, Na Střezině 1042 | powered by www.pry.cz

1
SELECT template FROM zus_templates_menu WHERE client_id='0' AND menuid='0'
2
SELECT template FROM zus_templates_menu WHERE client_id='0' AND menuid='192' LIMIT 1
3
DELETE FROM zus_session
WHERE (time < 1716092859)
4
SELECT * FROM zus_session WHERE session_id='a6e1e2a915b47c78188c74d57c77a230'
5
SELECT session_id FROM zus_session WHERE session_id=MD5('c19ba1aa77352423cbf5aaaf46628205')
6
INSERT INTO zus_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'c5d32d0c112588070c542161a42a1d96','1716093759','','0','1' )
7
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM zus_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
8
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM zus_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
9
SELECT access FROM zus_menu WHERE id='192'
10
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM zus_content AS a
 LEFT JOIN zus_categories AS cc ON cc.id = a.catid
 LEFT JOIN zus_sections AS s ON s.id = cc.section AND s.scope='content'
 LEFT JOIN zus_users AS u ON u.id = a.created_by
 LEFT JOIN zus_content_rating AS v ON a.id = v.content_id
 LEFT JOIN zus_groups AS g ON a.access = g.id
 WHERE a.id='621' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-05-19 06:42:39')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-05-19 06:42:39')
 AND a.access <= 0
11
UPDATE zus_content SET hits=(hits+1) WHERE id='621'
12
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM zus_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
13
SELECT id FROM zus_mambots WHERE element = 'mosimage' AND folder = 'content'
14
SELECT * FROM zus_mambots WHERE id='1'
15
SELECT a.id
 FROM zus_components AS a
 WHERE a.name = 'Syndicate'
16
SELECT * FROM zus_components WHERE id='17'
17
SELECT id, title, module, position, content, showtitle, params
FROM zus_modules AS m, zus_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '192' OR mm.menuid = '0')
ORDER BY ordering
18
SELECT m.* FROM zus_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
19
SELECT m.* FROM zus_menu AS m
WHERE menutype='mainmenu_stylguittar' AND published='1' AND access <= '0'
ORDER BY parent,ordering
20
SELECT id 
FROM zus_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=185'
21
SELECT id 
FROM zus_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=185'
22
SELECT id 
FROM zus_menu 
WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=187'
23
SELECT id 
FROM zus_menu 
WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=187'
24
SELECT m.* FROM zus_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
25
SELECT count(*) AS numrows FROM zus_banner WHERE showBanner=1
AND cid in (3)
26
SELECT * FROM zus_banner WHERE showBanner=1 
AND cid in (3)
LIMIT 0,1
27
UPDATE zus_banner SET impmade=impmade+1 WHERE bid='5'
28
SELECT *
FROM zus_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
29
SELECT id, name, link, parent, type
FROM zus_menu
WHERE published='1'
ORDER BY parent, ordering