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 Přidělení žáků k jednotlivým vyučujícím & zápis ke studiu Napsal -bor-    Pátek, 28 srpna 2009    Rozpis přidělení žáků k jednotlivým vyučujícím stahujte zde: soubor PDF   Rozvrh zápisu k jednotlivým vyučujícím HUDEBNÍHO OBORU stahujte zde: PDF  XLS Vyučující LITERÁRNĚ-DRAMATICKÉHO, TANEČNÍHO a VÝTVARNÉHO OBORU jsou k dispozici 1. a 2. září 2009 od 12.00 do 17.00 hodin. V době nepřítomnosti Vašeho učitele lze zápis provést u kteréhokoli jiného vyučujícího daného oboru!   < 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 je moudrý? Ten kdo se dovede od každého něco přiučit. Kdo je mocný? Kdo se vždy ovládne. Kdo je bohatý? Ten kdo je spokojen. A kdo je to? Nikdo. B. FRANKLIN 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 < 1732605812)
4
SELECT * FROM zus_session WHERE session_id='42fe936c280140f69f505942f8a9cc10'
5
SELECT session_id FROM zus_session WHERE session_id=MD5('a99f485ce2a308cfb1eba9a7efe0c064')
6
INSERT INTO zus_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '2a78582351598c696b1daf436d6e9e37','1732606712','','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='734' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2024-11-26 08:38:32')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2024-11-26 08:38:32')
 AND a.access <= 0
11
SELECT a.id
 FROM zus_content AS a
 WHERE a.catid = 119
 AND a.state = 1 AND ordering < 10
 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 > 10
 AND a.access <= '0'
 ORDER BY a.ordering
 LIMIT 1
13
UPDATE zus_content SET hits=(hits+1) WHERE id='734'
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 id FROM zus_mambots WHERE element = 'mosimage' AND folder = 'content'
16
SELECT * FROM zus_mambots WHERE id='1'
17
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='136'
18
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'
19
SELECT a.id
 FROM zus_components AS a
 WHERE a.name = 'Syndicate'
20
SELECT * FROM zus_components WHERE id='17'
21
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
22
SELECT m.* FROM zus_menu AS m
WHERE menutype='topmenu' AND published='1' AND access <= '0' AND parent='0'
ORDER BY ordering
23
SELECT m.* FROM zus_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
24
SELECT count(*) AS numrows FROM zus_banner WHERE showBanner=1
AND cid in (3)
25
SELECT * FROM zus_banner WHERE showBanner=1 
AND cid in (3)
LIMIT 0,1
26
UPDATE zus_banner SET impmade=impmade+1 WHERE bid='5'
27
SELECT *
FROM zus_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
28
SELECT id, name, link, parent, type
FROM zus_menu
WHERE published='1'
ORDER BY parent, ordering
29
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-26 08:38:32' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-26 08:38:32' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 10
30
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'
31
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'
32
SELECT COUNT( id )
 FROM zus_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
33
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
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_blog_section' AND m.published='1' AND i.id=851
35
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
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=850
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_blog_section' AND m.published='1' AND i.id=850
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_section' AND m.published='1' AND i.id=848
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=847
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=847
41
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
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_blog_section' AND m.published='1' AND i.id=846
43
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
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=845
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=845
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=844
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=844
48
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
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_blog_section' AND m.published='1' AND i.id=842
50
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
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_section' AND m.published='1' AND i.id=841
52
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
53
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
54
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
55
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-26 08:38:32') 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-11-26 08:38:32')
 AND catid='93' 
 ORDER BY a.ordering
56
SELECT * FROM zus_content WHERE id='254'
57
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
58
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
59
SELECT id, text FROM zus_poll_data
WHERE pollid='3' AND text <> ''
ORDER BY id