1
SELECT * FROM mos_menu ORDER BY name
2
SELECT template, client_id, menuid FROM mos_templates_menu WHERE (client_id=0 or client_id=1) AND (menuid=0 OR menuid=1) ORDER BY client_id, menuid
3
DELETE FROM mos_session WHERE (time<1780992738 AND guest>=0) OR (time<1780990038 AND guest<0)
4
SELECT * FROM mos_session WHERE session_id='bbe0c5b79914cf41abed8e6e99d44c19'
5
SELECT session_id FROM mos_session WHERE session_id=MD5('e0a0569d10200717ce310236f6be7150')
6
INSERT INTO mos_session ( `session_id`,`time`,`userid`,`username`,`gid`,`guest` ) VALUES ( '975b12de0a59d0da423e1337e3ad1c77','1780993638','0','','0','1' ) 
7
SELECT count(*), type FROM mos_stats_agents WHERE (agent='Mozilla 5.0' AND type=0) OR (agent='Unknown' AND type=1) OR (agent='Unknown' AND type=2) GROUP BY type
8
INSERT INTO mos_stats_agents (agent,type) VALUES ('Mozilla 5.0',0)
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type=1
10
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type=2
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Mozilla 5.0' AND type=0
12
SELECT folder, element, published, params, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0
ORDER BY ordering
13
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
 LEFT JOIN mos_categories AS cc ON cc.id = a.catid
 LEFT 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 <= '2026-06-09 02:27:19'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-09 02:27:19' )
 ORDER BY f.ordering