|
|
V�sledky dodate�n�ch talentov�ch zkou�ek |
|
Napsal admin
|
|
�ter�, 31 srpna 2010 |
Výsledky dodate�ných talentových zkoušek - viz p�íloha
|
|
|
|
|
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
|
|
|
� 2010 ZU�, Hradec Kr�lov�, Na St�ezin� 1042 | powered by www.pry.cz |
|
57 queries executed1
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 < 1745993135)
4
SELECT * FROM zus_session WHERE session_id='cd51048c5a987c615cb0c3cefd761954'
5
SELECT session_id FROM zus_session WHERE session_id=MD5('86e2bf4d1099f843ade9d3e76b9188b2')
6
INSERT INTO zus_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '0c089d95d00e7adb046c9cc0b4f9882e','1745994035','','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='832' AND (a.state = '1' OR a.state = '-1')
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2025-04-30 08:20:35')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2025-04-30 08:20:35')
AND a.access <= 0
11
SELECT a.id
FROM zus_content AS a
WHERE a.catid = 119
AND a.state = 1 AND ordering < 4
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 > 4
AND a.access <= '0'
ORDER BY a.ordering
LIMIT 1
13
UPDATE zus_content SET hits=(hits+1) WHERE id='832'
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 <= '2025-04-30 08:20:35' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-30 08:20:35' )
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 <= '2025-04-30 08:20:35')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-04-30 08:20:35')
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
