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<1284073685 AND guest>=0) OR (time<1284095085 AND guest<0)
3
SELECT * FROM mos_session WHERE session_id='4fa0c918d72b4d9add965af3016b24a4'
4
SELECT session_id FROM mos_session WHERE session_id=MD5('5edfc37be30373f3cb964d2375477a80')
5
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '91723c9f647ef296aaca66a580833293','1284098685','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 a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, cc.name AS category, g.name AS groups, s.title AS section
 FROM mos_content AS a
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 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_sections AS s ON a.sectionid = s.id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-09 22:04:45' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 22:04:45' )
 AND a.access <= '0'
 AND s.access<=0
 ORDER BY cc.ordering, a.created DESC
9
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'
10
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'
11
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
12
SELECT * FROM mos_mambots WHERE id='27'
13
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
14
SELECT * FROM mos_mambots WHERE id='24'
15
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
16
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 0,1
17
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='1'
18
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
19
SELECT * FROM mos_mambots WHERE id='23'
20
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
21
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
22
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
23
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
24
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
25
SELECT * FROM mos_mambots WHERE id='27'
26
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
27
SELECT * FROM mos_mambots WHERE id='24'
28
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
29
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 22,1
30
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='53'
31
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
32
SELECT * FROM mos_mambots WHERE id='23'
33
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
34
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
35
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
36
SELECT * FROM mos_mambots WHERE id='27'
37
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
38
SELECT * FROM mos_mambots WHERE id='24'
39
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
40
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 3,1
41
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='55'
42
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
43
SELECT * FROM mos_mambots WHERE id='23'
44
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
45
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
46
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
47
SELECT * FROM mos_mambots WHERE id='27'
48
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
49
SELECT * FROM mos_mambots WHERE id='24'
50
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
51
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 5,1
52
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='11'
53
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
54
SELECT * FROM mos_mambots WHERE id='23'
55
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
56
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
57
SELECT id FROM mos_mambots WHERE element = 'bot_adsense' AND folder = 'content'
58
SELECT * FROM mos_mambots WHERE id='27'
59
SELECT id FROM mos_mambots WHERE element = 'mosbanner' AND folder = 'content'
60
SELECT * FROM mos_mambots WHERE id='24'
61
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
62
SELECT * FROM mos_banner WHERE showBanner=1 LIMIT 13,1
63
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='36'
64
SELECT id FROM mos_mambots WHERE element = 'htmlfix' AND folder = 'content'
65
SELECT * FROM mos_mambots WHERE id='23'
66
SELECT g.*
FROM mos_core_acl_aro_groups AS g
INNER JOIN mos_core_acl_groups_aro_map AS gm ON gm.group_id = g.group_id
INNER JOIN mos_core_acl_aro AS ao ON ao.aro_id = gm.aro_id
WHERE ao.value='62'
67
SELECT COUNT(*)
FROM mos_core_acl_aro_groups AS g1
LEFT JOIN mos_core_acl_aro_groups AS g2 ON g1.lft > g2.lft AND g1.lft < g2.rgt
WHERE g1.group_id='25' AND g2.name='Public Frontend'
68
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
69
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=78
70
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=78
71
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=167
72
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=167
73
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Registered'
74
SELECT group_id FROM mos_core_acl_aro_groups WHERE name='Author'
75
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 22:04:45' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 22:04:45' )
 AND a.access <= '0'
 AND ( a.sectionid IN (8,4,3) )
 ORDER BY a.created DESC LIMIT 6
76
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'
77
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'
78
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
79
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
80
SELECT DISTINCT a.username
 FROM mos_session AS a
 WHERE (a.guest=0)
81
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 22:04:45' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-09 22:04:45' )
 AND a.access <= '0'
 ORDER BY a.hits DESC LIMIT 5
82
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'
83
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'
84
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=7
85
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=7
86
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=61
87
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=61
88
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=52
89
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=52
90
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=60
91
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=60
92
SELECT i.sectionid FROM mos_content AS i, mos_sections AS s WHERE i.sectionid=s.id AND i.id=9
93
SELECT i.catid FROM mos_content AS i, mos_categories AS s WHERE i.catid=s.id AND i.id=9
94
SELECT count(*) AS numrows FROM mos_banner WHERE showBanner=1
95
SELECT * FROM mos_banner WHERE showBanner=1 
LIMIT 21,1
96
UPDATE mos_banner SET impmade=impmade+1 WHERE bid='52'
97
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
98
SELECT id, text FROM mos_poll_data
WHERE pollid='27' AND text <> ''
ORDER BY id
99
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
100
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
101
SELECT * FROM mos_components WHERE id='17'
102
SELECT id FROM mos_modules WHERE published=1 AND module='mod_rssfeed'
103
SELECT a.params, a.option
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'