1
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=27) ORDER BY client_id, menuid
2
DELETE FROM mos_session WHERE (time<1284072833 AND guest>=0) OR (time<1284094233 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='5e64e738218f96e002b746133c5b4e82'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('132f24a987c638fbd444791eab8a80e5')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '273ea3883c63117bf1bf5f7aa88add28','1284097833','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 * FROM mos_categories WHERE id='7'
9
SELECT c.*, COUNT( b.id ) AS numitems
 FROM mos_categories AS c
 LEFT JOIN mos_content AS b ON b.catid = c.id 
 AND b.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-09 21:50:33' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-09 21:50:33' )
 AND b.access <= '0'
 WHERE c.section = '3'
 AND c.published='1'
 AND c.access <= '0'
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
10
SELECT COUNT(a.id) as numitems
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid='7' 
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-09 21:50:33' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-09 21:50:33' )
 AND a.access<='0'
 AND '0'<='0'
 ORDER BY a.created DESC
11
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM mos_content AS a
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.catid='7' 
 AND a.state='1'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-09 21:50:33' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-09 21:50:33' )
 AND a.access<='0'
 AND '0'<='0'
 ORDER BY a.created DESC
 LIMIT 0, 20
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 = '27' 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 group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
20
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
21
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 21:50:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 21:50:33' )
 AND a.access <= '0'
 AND ( a.sectionid IN (8,4,3) )
 ORDER BY a.created DESC LIMIT 6
22
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
23
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
24
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
25
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
26
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)
27
SELECT a.id, a.title, a.sectionid, a.catid, a.hits
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 21:50:33' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 21:50:33' )
 AND a.access <= '0'
 ORDER BY a.hits DESC LIMIT 5
28
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
29
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
30
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=7
31
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=7
32
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=61
33
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=61
34
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=52
35
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=52
36
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=60
37
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=60
38
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=9
39
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=9
40
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
41
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 16,1
42
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='35'
43
SELECT p.id, p.title
FROM mos_polls AS p, mos_poll_menu AS pm
WHERE (pm.menuid='27' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
44
SELECT id, text FROM mos_poll_data
WHERE pollid='27' AND text <> ''
ORDER BY id
45
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
46
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
47
SELECT * FROM mos_components WHERE id='17'
48
SELECT id FROM mos_modules WHERE published=1 AND module='mod_rssfeed'
49
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'