SELECT *
FROM jos_session
WHERE session_id = '329e399b20dffcd0997ce4fa28f68050'
DELETE
FROM jos_session
WHERE ( time < '1781036166' )
SELECT *
FROM jos_session
WHERE session_id = '329e399b20dffcd0997ce4fa28f68050'
INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '329e399b20dffcd0997ce4fa28f68050','1781037066','','0','1','0' )
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 125)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 697
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-06-09 20:31:06' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-06-09 20:31:06' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='697'
SELECT a.id, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 103
AND a.state = 1
AND a.access <= 0
AND ( a.state = 1 OR a.state = -1 )
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-09 20:31:06' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-09 20:31:06' )
ORDER BY a.created DESC
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 125 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 125
LIMIT 1
SELECT parent, menutype, ordering
FROM jos_menu
WHERE id = 34
LIMIT 1
SELECT count(*)
FROM jos_menu AS m
WHERE menutype='mainmenu'
AND published='1'
AND access <= '0'
AND parent=0
AND ordering < 7
SELECT guest, usertype, client_id
FROM jos_session
WHERE client_id = 0
... befand sich die Klasse 10a am 30.11.2021. Ob KGB, Stasi oder auch CIA - die Nachrichtenbeschaffung und -übermittlung durch unterschiedlichste Methoden stand für alle Geheimdienste im Mittelpunkt. 
Einen Einblick bekamen die Schülerinnen und Schüler an diesem Wandertag im Spionagemuseum am Leipziger Platz in Berlin: 
"Wir konnten uns unsere Namen mit einem Morsecode drucken, interessante Fragen zum eigenen Leben stellen und sehen, ob wir diese richtig oder gelogen beantwortet haben. 
Auch das Entdecken von versteckten Sendern war eine lustige Sache. Wörter von den Lippen ablesen war auch nicht ganz einfach. Großen Spaß hatten alle aber beim Verkleiden und es entstanden tolle Fotos von der Klasse. Gar nicht trennen wollten wir uns vom Laserparcour - alles war so toll, dass wir diesen Tag jeder Klasse empfehlen wollen. Also viel Spaß und es gibt wirklich einiges zu entdecken und auszuprobieren!"
