1
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
2
SELECT `id`,`link` FROM mos_menu  WHERE ((`name` LIKE '%contact us%') AND (`published` > 0))
3
SELECT oldurl, newurl FROM mos_redirection WHERE oldurl = 'contact-us/2.html' LIMIT 1
4
UPDATE mos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_contact&Itemid;=58'
5
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 58 )
 ORDER BY menuid DESC
LIMIT 0, 1
6
DELETE FROM mos_session
 WHERE (
 ( time < '1205337690' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1205337690' )
 AND guest = 1
 AND userid = 0
 )
7
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
8
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
9
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
10
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
11
SELECT COUNT(*)
 FROM mos_stats_agents
 WHERE agent = 'com'
 AND type = 2
12
UPDATE mos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'com'
 AND type = 2
13
SELECT *
 FROM mos_menu
 WHERE id = 58
14
SELECT *, COUNT( a.id ) AS numlinks
 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
15
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=4&Itemid;=58'
16
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=68&Itemid;=58'
17
SELECT a.*
 FROM mos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu;=1' )
 AND a.option = 'com_syndicate'
18
SELECT id, title, module, position, content, showtitle, params
 FROM mos_modules AS m
 INNER JOIN mos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = '58' )
 ORDER BY ordering
19
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
20
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=20&Itemid;=49'
21
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM mos_content AS a
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-03-12 17:16' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-03-12 17:16' )
 AND a.catid = 3
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
22
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid = s.id
 LEFT JOIN mos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN mos_categories AS c ON i.catid = c.id
 LEFT JOIN mos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 141
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
23
SELECT id 
 FROM mos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
24
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
25
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
26
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_frontpage&Itemid;=112'
27
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=20&Itemid;=49'
28
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogcategory&id;=102&Itemid;=73'
29
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=4&Itemid;=58'
30
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type = 'content_typed'
 AND published = 1
31
SELECT id
 FROM mos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task;=view&id;=87'
32
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=87&Itemid;=85'
33
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=21&Itemid;=48'
34
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=13&Itemid;=42'
35
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=24&Itemid;=55'
36
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&Itemid;=58'
37
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=login'
38
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=lostPassword'
39
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_comprofiler&task;=registers'
40
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
41
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogsection&id;=9&Itemid;=100'
42
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=view&id;=22&Itemid;=50'
43
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=blogcategory&id;=103&Itemid;=74'
44
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_contact&catid;=4&Itemid;=67'
45
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task;=category§ionid;=10&id;=123&Itemid;=108'