1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1265688706)
5
SELECT * FROM mos_session WHERE session_id='7fd612e64f9361b408292c9558f139fe'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('0e25285769f7a295dd6ffd4c0f8cbbee')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '675c91e2123861531c687d9992f3ea8a','1265689606','','0','1' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
15
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
16
SELECT access FROM mos_menu WHERE id='1'
17
SELECT * FROM mos_menu WHERE id='1'
18
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 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.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-02-09 11:26:46'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-02-09 11:26:46' )
 ORDER BY f.ordering
19
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'
20
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'
21
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
22
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
23
SELECT id FROM mos_mambots WHERE element = 'mosimage' AND folder = 'content'
24
SELECT * FROM mos_mambots WHERE id='1'
25
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
26
SELECT * FROM mos_mambots WHERE id='16'
27
SELECT 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_section' AND m.published='1' AND i.id=64
28
SELECT 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' AND i.id=64
29
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
30
SELECT id FROM mos_mambots WHERE element = 'mosimage' AND folder = 'content'
31
SELECT * FROM mos_mambots WHERE id='1'
32
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
33
SELECT * FROM mos_mambots WHERE id='16'
34
SELECT 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_section' AND m.published='1' AND i.id=63
35
SELECT 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' AND i.id=63
36
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
37
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
38
SELECT * FROM mos_mambots WHERE id='16'
39
SELECT 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_section' AND m.published='1' AND i.id=59
40
SELECT 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' AND i.id=59
41
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
42
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
43
SELECT * FROM mos_mambots WHERE id='16'
44
SELECT 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_section' AND m.published='1' AND i.id=58
45
SELECT 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' AND i.id=58
46
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
47
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
48
SELECT * FROM mos_mambots WHERE id='16'
49
SELECT 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_section' AND m.published='1' AND i.id=57
50
SELECT 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' AND i.id=57
51
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
52
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
53
SELECT * FROM mos_mambots WHERE id='16'
54
SELECT 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_section' AND m.published='1' AND i.id=56
55
SELECT 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' AND i.id=56
56
SELECT 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_section' AND m.published='1' AND i.id=55
57
SELECT 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' AND i.id=55
58
SELECT 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_section' AND m.published='1' AND i.id=54
59
SELECT 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' AND i.id=54
60
SELECT 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_section' AND m.published='1' AND i.id=53
61
SELECT 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' AND i.id=53
62
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
63
SELECT * FROM mos_components WHERE id='17'
64
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
65
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
66
SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
67
SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
68
SELECT sum(hits) AS count FROM mos_stats_agents WHERE type='1'
69
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
70
SELECT id, text FROM mos_poll_data
WHERE pollid='17' AND text <> ''
ORDER BY id