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 = 37 )
ORDER BY menuid DESC
LIMIT 13
DELETE FROM jos_session
WHERE (
( time < '1729607577' )
AND guest = 0
AND gid > 0
) OR (
( time < '1729607577' )
AND guest = 1
AND userid = 0
)4
SELECT *
FROM jos_session
WHERE session_id = '05d63bcb160c3dd575592ea805efc7fe'5
UPDATE jos_session SET `time`='1729608477',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1' WHERE session_id='05d63bcb160c3dd575592ea805efc7fe'6
SELECT *
FROM jos_menu
WHERE id = 377
SELECT a.id FROM `jos_components` AS a
WHERE `a`.`option` = 'com_letterman' AND `parent` = 08
SELECT *
FROM jos_components
WHERE id = '84'9
SELECT name FROM jos_menu WHERE id='37'10
SELECT id FROM jos_users, jos_letterman_subscribers WHERE user_id=id AND user_id='0'11
SELECT id FROM jos_modules WHERE module = 'mod_lettermansubscribe'12
SELECT *
FROM jos_modules
WHERE id = '53'13
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'14
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 = 37 )
ORDER BY ordering15
SELECT guest, usertype
FROM jos_session16
SELECT DISTINCT a.username
FROM jos_session AS a
WHERE a.guest = 0 AND usertype <> 'Super Administrator'17
SELECT m.*
FROM jos_menu AS m
WHERE menutype = 'mainmenu'
AND published = 1
AND access <= 0
ORDER BY parent, ordering18
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 119
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=15'20
SELECT id
FROM jos_menu
WHERE type = 'content_item_link'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=60'21
SELECT COUNT( id )
FROM jos_menu
WHERE type = 'content_typed'
AND published = 122
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=70'23
SELECT id
FROM jos_menu
WHERE type = 'content_typed'
AND published = 1
AND link = 'index.php?option=com_content&task=view&id=71'24
SELECT *
FROM jos_users
WHERE id = '0'25
SELECT id
FROM jos_menu
WHERE type = 'components'
AND published = 1
AND link = 'index.php?option=com_letterman'26
SELECT *
FROM jos_banner
WHERE showBanner=127
UPDATE jos_banner
SET impmade = impmade + 1
WHERE bid = 5