South Texas Council BSA National   Home Links Contact Us Advancement Training Units Camps Login Form Username Password Remember me Lost Password? Home New Philmont Requirement Philmont has a new training requirements effective in 2008.  These are Wilderness First Aid and When Care Is Delayed.  These courses will be offerred by the Crossroads Chapter American Red Cross.  For additional information, contact Dorothy Cisneros, Health/Safety Coordinator at 573-2674. She will be teaching these courses.   DeLeon District Roundtable First Thursday of month at OLV cafeteria, 7 pm.   Training Cubmasters, Scoutmasters and Scouters, If you need training please contact me via the link on the webpage so that we can set this up.   2007 Scouting for Food Scouting for Food 2007 was a great success!  Thanks to Lydia Huber for coordinating our efforts. Read more for the totals by Unit. Read more...   Nuts for Knots!    Have you seen the latest cool website? Check out http://www.animatedknots.com/ You can watch these knots being tied!   Scout Stuff Online! Scouters don't miss out,  you can now purchase scout stuff online. Click Here to check it out!

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 id, link
 FROM mos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM mos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM mos_session
 WHERE (
 ( time < '1211011297' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1211100397' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM mos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 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_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-18 04:01' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-18 04:01' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 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_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2008-05-18 04:01' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2008-05-18 04:01' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 10
9
SELECT folder, element, published, params
 FROM mos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
10
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'
11
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 = 1 )
 ORDER BY ordering
12
SELECT m.*
 FROM mos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
13
SELECT id
 FROM mos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
14
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
15
SELECT id, name, link, parent, type, menutype, access
 FROM mos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering