Boaters Christian Fellowship
Home
Main Menu
Home
Who are we?
An important message
Diary of Events
How to Join
Downloads
Links
Contact Us
Church Directory
Search
Prayer Requests
Visitors Book
The Word
Website Administration
Who's Online
We have 6 guests online
Statistics
Visitors: 1474489
Calendar
July 2009 August 2009
Su Mo Tu We Th Fr Sa
Week 27 1 2 3 4
Week 28 5 6 7 8 9 10 11
Week 29 12 13 14 15 16 17 18
Week 30 19 20 21 22 23 24 25
Week 31 26 27 28 29 30 31
BCF Website
Welcome to our website!
We are very pleased that you have paid us a visit, and we invite you to browse our pages. Select from the menus to view.
 
Sorry if you have been unable to log in we have some problems but are working on them.
 

Alan and Hazel Dilnot - Our joint Chair alongside their narrow boat "Dilly Dally"
 

Alan & Hazel Dilnot 002.jpg




 

Read more...
Latest
Events
July
Stratford on Avon River Festival
July 3 (09:00) - July 05 (2359), 2009
(General) BCF Stand and Church Service
August
IWA Festival
August 28 (09:00) - August 31 (2359), 2009
(National) Red Hill on River Soar

IWA National Rally
August 28 (10:00) - August 31 (2359), 2009
(General) Red Hill River Soar 8am Sunday Holy Communion for Boaters 10.30am Sunday Celebration Praise
September
Boaters Bible Conference
September 4 (10:00) - September 08 (2359), 2009
(General) Canal Ministries will be leading Please book through Julie Thorn

Boaters Bible Conference
September 4 (15:00) - September 08 (2359), 2009
(General) A Bible Study Weekend organised bt the members of Canal Ministries for all boaters. To be held at ' The Taft'

Black Country Boating Festival
September 12 (09:00) - September 13 (2359), 2009
(Joint West Midlands Region) Windmill End nr Netherton Tunnel

BBQ
September 12, 2009 (18:00 - 2359)
(East Midlands Region) At "The Taft"

BBQ
September 13, 2009 (11:00 - 1500)
(East Midlands Region) The Taft Wolseley Bridge Staffs

Mission in Stone
September 16 (09:00) - September 23 (2359), 2009
(General) Mission in Stone with the Stone Churches

View Full Calendar
©2009 Boaters Christian Fellowship Registered Charity No. 1101100
125 queries executed
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 DELETE FROM mos_session WHERE (time < 1246575768)
5 SELECT * FROM mos_session WHERE session_id='d399c2b414507b62d54bf25221bf8c4f'
6 SELECT session_id FROM mos_session WHERE session_id=MD5('f163667bdf9987fbf071d97c260aa050')
7 INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'bc86c746ad5e9ef9b88227cc06bf00f8','1246576668','','0','1' )
8 SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9 UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10 SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11 UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12 SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13 UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14 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
15 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
16 SELECT access FROM mos_menu WHERE id='1'
17 SELECT * FROM mos_menu WHERE id='1'
18 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 <= '2009-07-03 00:17:49' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-03 00:17:49' ) ORDER BY f.ordering
19 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'
20 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'
21 SELECT COUNT( id ) FROM mos_menu WHERE type='content_blog_section' AND published='1' AND componentid=0
22 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
23 SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
24 SELECT * FROM mos_mambots WHERE id='16'
25 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
26 SELECT a.id FROM mos_components AS a WHERE a.name = 'Syndicate'
27 SELECT * FROM mos_components WHERE id='17'
28 SELECT a.id FROM mos_components AS a WHERE a.name = 'Syndicate'
29 SELECT * FROM mos_components WHERE id='17'
30 SELECT id FROM mos_modules WHERE published=1 AND module='mod_rssfeed'
31 SELECT a.*, u.name AS author, u.usertype FROM mos_content AS a INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id LEFT JOIN mos_users AS u ON u.id = a.created_by WHERE a.state = '1' AND a.access = 0 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-03 00:17:49' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-03 00:17:49' ) ORDER BY f.ordering LIMIT 5
32 SELECT id FROM mos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=1'
33 SELECT id FROM mos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=1'
34 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
35 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_blog_section' AND m.published='1' AND i.id=1
36 SELECT 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' AND i.id=1
37 SELECT id FROM mos_menu WHERE type='content_blog_section' AND published='1' AND componentid=0
38 SELECT id FROM mos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=5'
39 SELECT id, title, module, position, content, showtitle, params FROM mos_modules AS m, mos_modules_menu AS mm WHERE m.published='1' AND m.access <= '0' AND m.client_id='0' AND mm.moduleid=m.id AND (mm.menuid = '1' OR mm.menuid = '0') ORDER BY ordering
40 SELECT * FROM mos_menu WHERE menutype='mainmenu' AND published='1' ORDER BY parent, ordering LIMIT 1
41 SELECT id, name, link, parent, type FROM mos_menu WHERE published='1' ORDER BY parent, ordering
42 SELECT m.* FROM mos_menu AS m WHERE menutype='mainmenu' AND published='1' AND access <= '0' ORDER BY parent,ordering
43 SELECT id FROM mos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=70'
44 SELECT id FROM mos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=70'
45 SELECT count(session_id) as guest_online FROM mos_session WHERE guest=1 AND (usertype is NULL OR usertype='')
46 SELECT DISTINCT count(username) as user_online FROM mos_session WHERE guest=0 AND usertype <> 'administrator' AND usertype <> 'superadministrator'
47 SELECT DISTINCT a.username FROM mos_session AS a WHERE (a.guest=0)
48 SELECT m.* FROM mos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' ORDER BY parent,ordering
49 SELECT sum(hits) AS count FROM mos_stats_agents WHERE type='1'
50 SELECT * FROM mos_extcal_config
51 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090701 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
52 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090701) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
53 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090702 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
54 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090702) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
55 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090703 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
56 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090703) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
57 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090704 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
58 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090704) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
59 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090705 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
60 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090705) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
61 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090706 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
62 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090706) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
63 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090707 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090707) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
65 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090708 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
66 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090708) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
67 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090709 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
68 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090709) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
69 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090710 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
70 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090710) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
71 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090711 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
72 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090711) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
73 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090712 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
74 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090712) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
75 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090713 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
76 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090713) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
77 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090714 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090714) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
79 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090715 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
80 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090715) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
81 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090716 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090716) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
83 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090717 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090717) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
85 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090718 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
86 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090718) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
87 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090719 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090719) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
89 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090720 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
90 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090720) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
91 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090721 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
92 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090721) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
93 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090722 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090722) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
95 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090723 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
96 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090723) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
97 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090724 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090724) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
99 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090725 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090725) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
101 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090726 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090726) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
103 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090727 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090727) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
105 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090728 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090728) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
107 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090729 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090729) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
109 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090730 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090730) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
111 SELECT e.extid, start_date, end_date from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20090731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20090731 ) ) AND c.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
112 SELECT e.extid, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20090731) AND c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
113 SELECT a.id, a.title, a.sectionid FROM mos_content AS a WHERE ( a.state = '1' AND a.checked_out = '0' ) AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-03 00:17:49' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-03 00:17:49' ) AND a.access <= '0' ORDER BY a.created DESC LIMIT 6
114 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'
115 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'
116 SELECT COUNT( id ) FROM mos_menu WHERE type='content_blog_section' AND published='1' AND componentid=0
117 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 24
118 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 23
119 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 22
120 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 21
121 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 20
122 SELECT id FROM mos_menu WHERE type = 'content_typed' AND componentid = 19
123 SELECT MAX(id) FROM mos_menu WHERE link LIKE '%index.php?option=com_extcalendar%' AND published <> '-2'
124 SELECT e.*,cat,cat_name from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE ( ( ( UNIX_TIMESTAMP(e.end_date) >= UNIX_TIMESTAMP('2009-07-03 00:17:49') ) OR ( UNIX_TIMESTAMP(e.start_date) >= UNIX_TIMESTAMP('2009-07-03 00:17:49') ) ) OR ( e.end_date = '0000-00-00 00:00:01' ) ) AND c.published = '1' AND approved = '1' AND recur_type = '' ORDER BY e.start_date,e.title ASC LIMIT 12
125 SELECT e.*,cat,cat_name from mos_extcal_events AS e LEFT JOIN mos_extcal_categories AS c ON e.cat=c.cat_id WHERE c.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY e.start_date,e.title ASC