Dankeschön für das Herunterladen der Datei ProgrammChor2012
Falls der Download nicht automatisch startet, dann klicke auf den Link DOWNLOAD
Letzte Änderung am:
13 May 2012
Letzte Änderung durch:
Domy (Domy)
Dateidatum:
13 May 2012
Dateiversion:
1.0
Dateigröße:
73.41 Kb
Dateityp:
pdf
Downloads:
24
34 queries executed
1
SELECT folder, element, published, params
FROM jos_mambots
WHERE published >= 1
AND access <= 0
AND folder = 'system'
ORDER BY ordering2
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND ( menuid = 0 OR menuid = 43 )
ORDER BY menuid DESC
LIMIT 13
DELETE FROM jos_session
WHERE (
( time < '1729607578' )
AND guest = 0
AND gid > 0
) OR (
( time < '1729607578' )
AND guest = 1
AND userid = 0
)4
SELECT *
FROM jos_session
WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'5
UPDATE jos_session SET `time`='1729608478',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'6
SELECT *
FROM jos_menu
WHERE id = 437
SELECT * FROM jos_downloads_repository WHERE id=08
SELECT fileid, COUNT(fileid) AS number FROM jos_downloads_log WHERE type = 1 AND ipaddress = '18.118.144.97' AND date > SUBDATE(NOW(), INTERVAL 24 HOUR) GROUP BY fileid9
SELECT role, subject_id, action FROM jos_permissions WHERE subject_type = 'remosFolder' AND action IN('download','edit')10
SELECT f.*, AVG(l.value) AS vote_value, COUNT(l.value) AS vote_count FROM jos_downloads_files AS f LEFT JOIN jos_downloads_log AS l ON l.type=3 AND l.fileid=f.id WHERE f.id = 6 AND published=1 GROUP BY f.id11
SELECT COUNT(*) FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')12
SELECT `role`, `control`, `subject_id`, `action` FROM `jos_permissions` WHERE `subject_type`='remosFolder' AND (`action`='download' OR `action`='*')13
SELECT *
FROM jos_users
WHERE id = '62'14
SELECT fileid, COUNT(fileid) AS number FROM jos_downloads_log WHERE type = 1 AND userid = 62 AND date > SUBDATE(NOW(), INTERVAL 24 HOUR) GROUP BY fileid15
SELECT role, access_id FROM jos_assignments AS a WHERE a.access_type='aUser' AND (a.access_id='62' OR a.access_id='*' OR a.access_id='+')16
SELECT * FROM jos_downloads_containers ORDER BY sequence, name17
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder18
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder19
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder20
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder21
SELECT id, (CASE menutype WHEN 'mainmenu' THEN 1 WHEN 'topmenu' THEN 2 WHEN 'othermenu' THEN 3 ELSE 99 END) menorder FROM jos_menu WHERE link = 'index.php?option=com_remository' AND published=1 ORDER BY menorder22
SELECT a.*
FROM jos_components AS a
WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
AND a.option = 'com_syndicate'23
SELECT id, title, module, position, content, showtitle, params
FROM jos_modules AS m
INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id != 1
AND ( mm.menuid = 0 OR mm.menuid = 43 )
ORDER BY ordering24
SELECT guest, usertype
FROM jos_session25
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE a.guest = 0 AND usertype <> 'Super Administrator'26
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering27
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 128
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=15'29
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=60'30
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 131
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=70'32
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=71'33
SELECT *
FROM jos_banner
WHERE showBanner=134
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5