South Texas Council BSA National   Top Module Empty Home Links Contact Us Advancement Training Units Camps Home Links High Adventure   Web Link      Florida Sea Base      Philmont      Northern Tier   High Adventure   (3) Scouting Religous Awards   (3) Troop Web Sites   (1) Pack Web Sites   (1)

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 23 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM mos_session
 WHERE (
 ( time < '1219826436' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1219915536' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM mos_menu
 WHERE id = 23
6
SELECT id, url, title, description, date, hits, params
 FROM mos_weblinks
 WHERE catid = 37
 AND published = 1
 AND archived = 0
 ORDER BY ordering
7
SELECT *
 FROM mos_categories
 WHERE id = 37
 AND published = 1
 AND access <= 0
8
SELECT cc.*, a.catid, a.title, a.url, COUNT(a.id) AS numlinks
 FROM mos_categories AS cc
 LEFT JOIN mos_weblinks AS a ON a.catid = cc.id
 WHERE a.published = 1
 AND section = 'com_weblinks'
 AND cc.published = 1
 AND cc.access <= 0
 GROUP BY cc.id
 ORDER BY cc.ordering
9
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'
10
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 = 23 )
 ORDER BY ordering
11
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
12
SELECT id
 FROM mos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
13
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
14
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering