GUITARREANDO VÝTVARKA TANEC DIVADLO HUDBA INFORMACE ZUŠ 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 Ředitelské volno Napsal Jan Švandrlík    Středa, 22 září 2010 V pondělí 27. září 2010 výuka odpadá. Je vyhlášeno ředitelské volno. V úterý 28. září je státní svátek. < Předch.   Další > [Zpět] Nejnovější články Změna webových stránek školy K.H.M - výstava prací žáků výtvarného oboru Program Divadla Jesličky na listopad 2010 Pozvánka na představení Obsese v Divadle Jesličky V týdnu od 25. do 29. 10. 2010 se nevyučuje Pozvánka na LOGO Show Pozvánka na představení Divadla Jesličky Pozvánka na koncert 11.10.2010 Program divadla Jesličky na říjen 2010 Ředitelské volno Citát Kdo nemá peněz, je chudý; kdo nemá přátel, je chudší; ale kdo nemá srdce, je nejchudší na světě. F. M. DOSTOJEVSKIJ Anketka Jste spokojeni s tímto webem? Ano, velmi Ano Průměr Ne Vůbec ne © 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='1' LIMIT 1
3
DELETE FROM zus_session
WHERE (time < 1732545837)
4
SELECT * FROM zus_session WHERE session_id='9b624a0ac6d8b95f37dc0ddca8c0594a'
5
SELECT session_id FROM zus_session WHERE session_id=MD5('ffd93b7f9a9e66618d95b29089bc658f')
6
INSERT INTO zus_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '115be8c56da86a7305971a3d3051f221','1732546737','','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='1'
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='840' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-25 15:58:57')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-25 15:58:57')
 AND a.access <= 0
11
SELECT a.id
 FROM zus_content AS a
 WHERE a.catid = 119
 AND a.state = 1 AND ordering < 2
 AND a.access <= '0'
 ORDER BY a.ordering DESC
 LIMIT 1
12
SELECT a.id
 FROM zus_content AS a
 WHERE a.catid = 119
 AND a.state = 1 AND ordering > 2
 AND a.access <= '0'
 ORDER BY a.ordering
 LIMIT 1
13
UPDATE zus_content SET hits=(hits+1) WHERE id='840'
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='202'
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 = '1' 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' AND published='1' AND access <= '0'
ORDER BY parent,ordering
22
SELECT count(*) AS numrows FROM zus_banner WHERE showBanner=1
AND cid in (3)
23
SELECT * FROM zus_banner WHERE showBanner=1 
AND cid in (3)
LIMIT 0,1
24
UPDATE zus_banner SET impmade=impmade+1 WHERE bid='5'
25
SELECT *
FROM zus_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
26
SELECT id, name, link, parent, type
FROM zus_menu
WHERE published='1'
ORDER BY parent, ordering
27
SELECT a.id, a.title, a.sectionid, a.catid
 FROM zus_content AS a
 LEFT JOIN zus_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-25 15:58:57' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-25 15:58:57' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 10
28
SELECT COUNT( m.id )
 FROM zus_content AS i
 LEFT JOIN zus_sections AS s ON i.sectionid=s.id
 LEFT JOIN zus_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
29
SELECT COUNT( m.id )
 FROM zus_content AS i
 LEFT JOIN zus_categories AS c ON i.catid=c.id
 LEFT JOIN zus_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
30
SELECT COUNT( id )
 FROM zus_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
31
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=851
32
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=851
33
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_categories AS c ON i.catid=c.id
LEFT JOIN zus_menu AS m ON m.componentid=c.id 
WHERE m.type='content_blog_category' AND m.published='1' AND i.id=851
34
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=850
35
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=850
36
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=848
37
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=847
38
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=847
39
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=846
40
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=846
41
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_categories AS c ON i.catid=c.id
LEFT JOIN zus_menu AS m ON m.componentid=c.id 
WHERE m.type='content_blog_category' AND m.published='1' AND i.id=846
42
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=845
43
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=845
44
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=844
45
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=844
46
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=842
47
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=842
48
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_categories AS c ON i.catid=c.id
LEFT JOIN zus_menu AS m ON m.componentid=c.id 
WHERE m.type='content_blog_category' AND m.published='1' AND i.id=842
49
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=841
50
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=840
51
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_sections AS s ON i.sectionid=s.id
LEFT JOIN zus_menu AS m ON m.componentid=s.id 
WHERE m.type='content_blog_section' AND m.published='1' AND i.id=840
52
SELECT m.id 
FROM zus_content AS i
LEFT JOIN zus_categories AS c ON i.catid=c.id
LEFT JOIN zus_menu AS m ON m.componentid=c.id 
WHERE m.type='content_blog_category' AND m.published='1' AND i.id=840
53
SELECT a.id
 FROM zus_content AS a
 INNER JOIN zus_categories AS b ON b.id = a.catid
 WHERE a.state = 1
 AND a.access <= '0' AND b.access <= '0'
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-11-25 15:58:57') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-25 15:58:57')
 AND catid='93' 
 ORDER BY a.ordering
54
SELECT * FROM zus_content WHERE id='251'
55
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
56
SELECT p.id, p.title
FROM zus_poll_menu AS pm, zus_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
57
SELECT id, text FROM zus_poll_data
WHERE pollid='3' AND text <> ''
ORDER BY id