1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 80 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1280643174' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280643174' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '340e08711e39dfa8e84580dd6b37557f'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = 'd124b261afed427dbea4dea44b6725b2'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd124b261afed427dbea4dea44b6725b2','1280644074','','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 80
9
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'
10
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 = 80 )
 ORDER BY ordering
11
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
12
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
13
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=92'
14
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=119'
15
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=123'
16
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=201'
17
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
18
UPDATE jos_blastchatc_users SET session_id=sec_code, logged=0 WHERE logged=1 AND last_update<'1280643949'
19
DELETE FROM jos_blastchatc_users WHERE userid=0 AND logged=0
20
SELECT DISTINCT s.username, s.userid AS id, bcu.logged, bcu.last_update, bcu.roomid, bcu.room_serverid, bcu.roomname, bcu.idle, bcu.last_entry, cb.avatar, cb.avatarapproved  , cb.cb_sex AS cb_sfield  , u.lastvisitDate 
 FROM jos_session AS s 
 LEFT JOIN jos_blastchatc_users AS bcu ON (bcu.session_id=s.session_id) 
 LEFT JOIN jos_comprofiler AS cb ON (cb.user_id=s.userid) 
 LEFT JOIN jos_users AS u ON (u.id=s.userid)  WHERE s.guest=0
21
SELECT s.guest, s.usertype, bcu.logged, bcu.last_update FROM jos_session AS s  LEFT JOIN jos_blastchatc_users AS bcu ON (bcu.session_id=s.session_id)
22
SELECT global_count, global_update 
 FROM jos_blastchatc WHERE url=''
23
SELECT * FROM jos_swmenufree_config WHERE id = 1
24
SELECT jos_menu.* 
				FROM jos_menu
                WHERE jos_menu.menutype = 'topmenu' AND published = '1'
                ORDER BY parent, ordering