1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=26) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1284076950 AND guest>=0) OR (time<1284098350 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='bd73832e1e48e0d26665c535d5e48bfc'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('f486517ce0ee992b93b9e6677248e75b')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '9f52c4d743b946778efb6d139c8a8f1f','1284101950','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 group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
9
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
10
SELECT a.*, ROUND(v.rating_sum/v.rating_count) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT JOIN mos_sections AS s ON s.id = cc.section AND s.scope='content'
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.id='12' AND (a.state = '1' OR a.state = '-1')
	AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-09 22:59:10')
	AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-09 22:59:10')
 AND a.access <= 0
11
UPDATE mos_content SET hits=(hits+1) WHERE id='12'
12
SELECT hits
FROM mos_core_log_items
WHERE time_stamp='2010-09-10' AND item_table='#__content' AND item_id='12'
13
INSERT INTO mos_core_log_items VALUES
('2010-09-10','#__content','12','1')
14
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
15
SELECT * FROM mos_mambots WHERE id='27'
16
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
17
SELECT * FROM mos_mambots WHERE id='24'
18
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
19
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 10,1
20
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='14'
21
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
22
SELECT * FROM mos_mambots WHERE id='23'
23
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 = '26' OR mm.menuid = '0')
ORDER BY ordering
24
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
25
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=78
26
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
27
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=78
28
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=167
29
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=167
30
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
31
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
32
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)
33
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
34
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 24,1
35
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='57'
36
SELECT p.id, p.title
FROM mos_polls AS p, mos_poll_menu AS pm
WHERE (pm.menuid='26' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
37
SELECT id, text FROM mos_poll_data
WHERE pollid='27' AND text <> ''
ORDER BY id
38
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
39
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
40
SELECT * FROM mos_components WHERE id='17'
41
SELECT id FROM mos_modules WHERE published=1 AND module='mod_rssfeed'
42
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'