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
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
5
DELETE FROM mos_session
WHERE (time < 1210662005)
6
SELECT * FROM mos_session WHERE session_id='ffb3a31d45826595857f248d654b72ea'
7
SELECT session_id FROM mos_session WHERE session_id=MD5('9b5efe571e55ad4557e3f3b81c3f70f0')
8
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'ddba911e71b0cc22f75c5d1d1c90cf79','1210671006','','0','1' )
9
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
10
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
11
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
12
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
13
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
14
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
15
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
16
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
17
SELECT access FROM mos_menu WHERE id='1'
18
SELECT * FROM mos_menu WHERE id='1'
19
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 <= '2008-05-13 05:30:07'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2008-05-13 05:30:07' )
 ORDER BY f.ordering
20
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'
21
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'
22
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
23
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
24
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
25
SELECT * FROM mos_mambots WHERE id='16'
26
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=1
27
SELECT title_alias FROM mos_content WHERE id=1
28
SELECT s.title AS section, c.title AS category, a.title_alias AS title FROM mos_content as a LEFT JOIN mos_sections AS s ON a.sectionid=s.id LEFT JOIN mos_categories AS c ON a.catid=c.id WHERE a.id=1
29
SELECT oldurl FROM mos_redirection WHERE newurl = 'index.php?option=com_content&task=view&id=1&Itemid=1'