1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=3) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1283741124 AND guest>=0) OR (time<1283762524 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='64e292f62ef8b800c9af3d180f05dda9'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('ff684b1acf10f380f1b2d3f90f0a04e1')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( 'b23d0d621cbac5b23cb90fb2f5e85963','1283766124','0','','0','1' ) 
6
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
7
SELECT * FROM mos_menu ORDER BY name
8
SELECT cc.*,a.catid, COUNT(a.id) AS numlinks, MIN(a.id) as minimum
 FROM mos_categories AS cc
 LEFT JOIN mos_contact_details AS a ON a.catid = cc.id
 WHERE a.published='1'
 AND cc.section='com_contact_details'
 AND cc.published='1'
 AND a.access <= '0'
 AND cc.access <= '0'
 GROUP BY cc.id
 ORDER BY cc.ordering
9
SELECT a.*, a.id AS value, CONCAT_WS( ' - ', a.name, a.con_position ) AS text
 FROM mos_contact_details AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 WHERE a.published = '1'
 AND cc.published = '1'
 AND a.access <=0
 AND cc.access <=0
 ORDER BY a.default_con DESC, a.ordering ASC
10
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
11
SELECT * FROM mos_mambots WHERE id='16'
12
SELECT id, title, module, position, content, showtitle, params, published, m.access, m.groups
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '3' OR mm.menuid = '0')
ORDER BY ordering
13
SELECT i.id, i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id ORDER BY i.id DESC LIMIT 250
14
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=78
15
SELECT i.id, i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id ORDER BY i.id DESC LIMIT 250
16
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=78
17
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=167
18
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=167
19
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
20
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
21
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)
22
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
23
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 12,1
24
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='45'
25
SELECT p.id, p.title
FROM mos_polls AS p, mos_poll_menu AS pm
WHERE (pm.menuid='3' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
26
SELECT id, text FROM mos_poll_data
WHERE pollid='27' AND text <> ''
ORDER BY id
27
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
28
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
29
SELECT * FROM mos_components WHERE id='17'
30
SELECT id FROM mos_modules WHERE published=1 AND module='mod_rssfeed'
31
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'