Member Login

Ministries Church News Music Ministry WMU Ministry Youth Ministry Children's Ministry Royal Ambassadors Girls In Action Missions Zambia, Africa West Virginia Mission Opportunities Senior Saints Baptist Men Deacon Ministry

Missions Mission Opportunities  ( 1 items ) Upcoming Opportunities to Serve [ Back ] Home Contact Us News Links

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 40 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1283897894' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1283900594' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT *
 FROM jos_session
 WHERE session_id = '1652bece24dfe98d61bd5341022735db'
6
SELECT session_id
 FROM jos_session
 WHERE session_id = 'd875eb66854520aae0ebcbdc6dd81647'
7
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd875eb66854520aae0ebcbdc6dd81647','1283901494','','0','1' )
8
SELECT *
 FROM jos_menu
 WHERE id = 40
9
SELECT *
 FROM jos_sections
 WHERE id = '6'
10
SELECT a.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS a
 LEFT JOIN jos_content AS b ON b.catid = a.id
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2010-09-07 16:18' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2010-09-07 16:18' )
 WHERE a.section = '6'
 AND a.published = 1
 AND a.access <= 0
 AND b.access <= 0
 GROUP BY a.id
 HAVING numitems > 0
 ORDER BY a.ordering
11
SELECT a.*
 FROM jos_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'
12
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
13
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
14
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_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 = 40 )
 ORDER BY ordering
15
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Ministries'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
16
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
17
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1