GUITARREANDO VÝTVARKA TANEC DIVADLO HUDBA INFORMACE ZUŠ Divadlo Informace o studiu Učitelé oboru Novinky z oboru Úspěchy oboru Divadlo Jesličky Měsíčník Jesel Divadelní odkazy Fotogalerie 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 DIVADLO Střezina na Open Air programu Theatre European Regions 2008 Střezina na Open Air programu Theatre European Regions 2008 Napsal Jan Slavíček    Pondělí, 07 července 2008 Střezina na Open air programu XIV. ročníku Theatre European Regions 2008 - foto zde. < Předch.   Další > [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='101' LIMIT 1
3
DELETE FROM zus_session
WHERE (time < 1732587748)
4
SELECT * FROM zus_session WHERE session_id='c4ffb5fb8e8cc2ff71e5c5ac7a9c3bd2'
5
SELECT session_id FROM zus_session WHERE session_id=MD5('d4bcd56d050fa2a2e13a6a4f6fa12bb2')
6
INSERT INTO zus_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e42f0723786e0d2058c3ba694e1995a1','1732588648','','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='101'
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='590' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-26 03:37:28')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-26 03:37:28')
 AND a.access <= 0
11
SELECT a.id
 FROM zus_content AS a
 WHERE a.catid = 69
 AND a.state = 1 AND ordering < 8
 AND a.access <= '0'
 ORDER BY a.ordering DESC
 LIMIT 1
12
SELECT a.id
 FROM zus_content AS a
 WHERE a.catid = 69
 AND a.state = 1 AND ordering > 8
 AND a.access <= '0'
 ORDER BY a.ordering
 LIMIT 1
13
UPDATE zus_content SET hits=(hits+1) WHERE id='590'
14
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
15
SELECT g.*
FROM zus_core_acl_aro_groups AS g
INNER JOIN zus_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN zus_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='142'
16
SELECT COUNT(*)
FROM zus_core_acl_aro_groups AS g1
LEFT JOIN zus_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='24' AND g2.name='Public Frontend'
17
SELECT a.id
 FROM zus_components AS a
 WHERE a.name = 'Syndicate'
18
SELECT * FROM zus_components WHERE id='17'
19
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 = '101' OR mm.menuid = '0')
ORDER BY ordering
20
SELECT m.* FROM zus_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
21
SELECT m.* FROM zus_menu AS m
WHERE menutype='mainmenu_styldivadlo' AND published='1' AND access <= '0'
ORDER BY parent,ordering
22
SELECT m.* FROM zus_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
23
SELECT count(*) AS numrows FROM zus_banner WHERE showBanner=1
AND cid in (3)
24
SELECT * FROM zus_banner WHERE showBanner=1 
AND cid in (3)
LIMIT 0,1
25
UPDATE zus_banner SET impmade=impmade+1 WHERE bid='5'
26
SELECT *
FROM zus_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
27
SELECT id, name, link, parent, type
FROM zus_menu
WHERE published='1'
ORDER BY parent, ordering
28
SELECT title, catid FROM zus_content WHERE id=590