• .
• .
• .
• .
• ..

Use our Mobile Phone Site:    StFrancisville.Mobi,     for info on the road.       Tel:   (800) 789-4221      Email Us

Home

Events Calendar

Area News

Photo Gallery

Special Offerings

Contact Us

Local Updates Map & Info Updates Happenings News Ferry Status Cat Island Updates Map List Attractions Government Sites Historic District Lodging Main Map Parks, Wildlife Areas Restaurants & Bars Shops Wedding Facilities TRAVEL TOOLS Media Center Information Request Group Planning Environmental Friendly Film Opportunities Transportation ePostcards Sign-In Members SlideShow Pro Get the Flash Player to see this player.

Monthly View Flat View Weekly View Daily View Categories Search Weekly View Sun. 14 Mar, 2010 - Sat. 20 Mar, 2010 Previous Week Week 11 Next Week Sunday, March 14, 2010 Old West Florida “Colonial St. Francisville” – At Audubon SHS (12:00PM - 4:00PM) Friday, March 19, 2010 Audubon Pilgrimage (All Day) Avondale Antiques (9:00AM) Saturday, March 20, 2010 Audubon Pilgrimage (All Day) Avondale Antiques (9:00AM) Down-Hearth Cooking At Rosedown Plantation (10:00AM - 3:00PM) Feliciana Nature Society   Garden Club   General   Historical Society   La. State Historic Sites   Library   Main Street Program   WFP Tourist Commission           Search Calendar Powered by JCal Pro Calendar 1.5

Website by Blue Goose Media     Tourism Contacts:    This e-mail address is being protected from spam bots, you need JavaScript enabled to view it      Toll Free: 1 (800) 789.4221     Local:  (225) 635.4224

1
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 36 )
 ORDER BY menuid DESC
LIMIT 1
2
DELETE FROM jos_session
 WHERE (
 ( time < '1280596392' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280596392' )
 AND guest = 1
 AND userid = 0
 )
3
SELECT *
 FROM jos_session
 WHERE session_id = 'f4e460fc797830bf50ec62aae98b9907'
4
SELECT session_id
 FROM jos_session
 WHERE session_id = '83240b8bbdd74cb5b3e23fd2d159c222'
5
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '83240b8bbdd74cb5b3e23fd2d159c222','1280597292','','0','1' )
6
SELECT params
 FROM jos_mambots
 WHERE element = 'jfdatabase.systembot'
 AND folder = 'system'
7
SELECT * FROM jos_languages WHERE iso='en'
8
SELECT joomlatablename,tablepkID FROM `jos_jf_tableinfo`
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
13
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
14
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
15
SELECT *
 FROM jos_menu
 WHERE id = 36
16
SELECT * FROM jos_jcalpro_config
17
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
18
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
19
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
20
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 5 AND 10
GROUP BY g1.name
ORDER BY g1.lft
21
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
22
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
23
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
24
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
25
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
26
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
27
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='administrator'
28
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 16 AND 17
GROUP BY g1.name
ORDER BY g1.lft
29
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
30
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
31
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
32
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
33
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
34
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
35
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
36
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
37
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
38
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
39
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
40
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
41
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
42
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
43
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
44
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
45
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
46
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
47
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
48
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
49
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
50
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
51
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
52
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
53
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
54
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
55
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
56
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
57
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
58
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
59
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
60
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
61
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
62
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100314) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
63
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100314 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100314 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100314 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
64
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100314) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
65
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='351'
66
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
67
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
68
SELECT *
 FROM jos_mambots
 WHERE id = '25'
69
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
70
SELECT *
 FROM jos_mambots
 WHERE id = '23'
71
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
72
SELECT *
 FROM jos_mambots
 WHERE id = '22'
73
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100315) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
74
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100315 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100315 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100315 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
75
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100315) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
76
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100316) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
77
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100316 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100316 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100316 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
78
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100316) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
79
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100317) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
80
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100317 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100317 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100317 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
81
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100317) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
82
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100318) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
83
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100318 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100318 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100318 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
84
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100318) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
85
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100319) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
86
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100319 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100319 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100319 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
87
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100319) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
88
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='188'
89
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
90
SELECT *
 FROM jos_mambots
 WHERE id = '25'
91
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
92
SELECT *
 FROM jos_mambots
 WHERE id = '23'
93
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
94
SELECT *
 FROM jos_mambots
 WHERE id = '22'
95
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='379'
96
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
97
SELECT *
 FROM jos_mambots
 WHERE id = '25'
98
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
99
SELECT *
 FROM jos_mambots
 WHERE id = '23'
100
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
101
SELECT *
 FROM jos_mambots
 WHERE id = '22'
102
SELECT extid FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100320) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
103
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100320 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100320 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100320 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
104
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100320) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
105
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='188'
106
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
107
SELECT *
 FROM jos_mambots
 WHERE id = '25'
108
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
109
SELECT *
 FROM jos_mambots
 WHERE id = '23'
110
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
111
SELECT *
 FROM jos_mambots
 WHERE id = '22'
112
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='379'
113
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
114
SELECT *
 FROM jos_mambots
 WHERE id = '25'
115
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
116
SELECT *
 FROM jos_mambots
 WHERE id = '23'
117
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
118
SELECT *
 FROM jos_mambots
 WHERE id = '22'
119
SELECT e.*,cat_name, color, c.description AS cat_desc  FROM jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE extid='330'
120
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
121
SELECT *
 FROM jos_mambots
 WHERE id = '25'
122
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
123
SELECT *
 FROM jos_mambots
 WHERE id = '23'
124
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
125
SELECT *
 FROM jos_mambots
 WHERE id = '22'
126
SELECT cat_id, cat_name, description AS cat_desc, color FROM jos_jcalpro_categories WHERE published = 1 ORDER BY cat_name
127
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'
128
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0
ORDER BY ordering
129
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1'
130
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1
ORDER BY ordering
131
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND parent>0 AND published='1'
132
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1
ORDER BY ordering
133
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 = 36 )
 ORDER BY ordering
134
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
135
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
136
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
137
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
138
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'TempDetour'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
139
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=38'
140
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
141
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=40'
142
select * from jos_gmaps_maps order by title
143
select * from jos_gmaps_maps order by title
144
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (3) order by name
145
SELECT * from jos_gmaps_icons where icon = "flower.png"
146
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
147
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
148
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
149
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
150
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
151
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
152
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
153
SELECT * from jos_gmaps_icons where icon = "shop.png"
154
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (4) order by name
155
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
156
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (11) order by name
157
SELECT * from jos_gmaps_icons where icon = "shop.png"
158
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
159
SELECT * from jos_gmaps_config
160
SELECT * from jos_gmaps_icons where icon = "default.png"
161
SELECT * from jos_gmaps_icons where icon = "shop.png"
162
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
163
SELECT * from jos_gmaps_config
164
SELECT * from jos_gmaps_icons where icon = "default.png"
165
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
166
SELECT * from jos_gmaps_icons where icon = "shop.png"
167
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (7) order by name
168
SELECT * from jos_gmaps_icons where icon = "bed.png"
169
SELECT * from jos_gmaps_icons where icon = "bed.png"
170
SELECT * from jos_gmaps_icons where icon = "bed.png"
171
SELECT * from jos_gmaps_icons where icon = "bed.png"
172
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
173
SELECT * from jos_gmaps_icons where icon = "bed.png"
174
SELECT * from jos_gmaps_icons where icon = "bed.png"
175
SELECT * from jos_gmaps_icons where icon = "bed.png"
176
SELECT * from jos_gmaps_icons where icon = "bed.png"
177
SELECT * from jos_gmaps_icons where icon = "bed.png"
178
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
179
SELECT * from jos_gmaps_icons where icon = "bed.png"
180
SELECT * from jos_gmaps_icons where icon = "bed.png"
181
SELECT * from jos_gmaps_icons where icon = "bed.png"
182
SELECT * from jos_gmaps_icons where icon = "bed.png"
183
SELECT * from jos_gmaps_icons where icon = "bed.png"
184
SELECT * from jos_gmaps_icons where icon = "bed.png"
185
SELECT * from jos_gmaps_icons where icon = "bed.png"
186
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (5) order by name
187
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
188
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (6) order by name
189
SELECT * from jos_gmaps_icons where icon = "flower.png"
190
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
191
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
192
SELECT * from jos_gmaps_config
193
SELECT * from jos_gmaps_icons where icon = "default.png"
194
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
195
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
196
SELECT * from jos_gmaps_icons where icon = "flower.png"
197
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
198
SELECT * from jos_gmaps_icons where icon = "hiking.png"
199
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
200
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (8) order by name
201
SELECT * from jos_gmaps_icons where icon = "waiter.png"
202
SELECT * from jos_gmaps_icons where icon = "waiter.png"
203
SELECT * from jos_gmaps_icons where icon = "waiter.png"
204
SELECT * from jos_gmaps_icons where icon = "waiter.png"
205
SELECT * from jos_gmaps_icons where icon = "waiter.png"
206
SELECT * from jos_gmaps_icons where icon = "waiter.png"
207
SELECT * from jos_gmaps_icons where icon = "waiter.png"
208
SELECT * from jos_gmaps_icons where icon = "waiter.png"
209
SELECT * from jos_gmaps_icons where icon = "waiter.png"
210
SELECT * from jos_gmaps_icons where icon = "waiter.png"
211
SELECT * from jos_gmaps_icons where icon = "waiter.png"
212
SELECT * from jos_gmaps_icons where icon = "waiter.png"
213
SELECT * from jos_gmaps_icons where icon = "waiter.png"
214
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (2) order by name
215
SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
216
SELECT * from jos_gmaps_icons where icon = "shop.png"
217
SELECT * from jos_gmaps_icons where icon = "shop.png"
218
SELECT * from jos_gmaps_icons where icon = "shop.png"
219
SELECT * from jos_gmaps_icons where icon = "shop.png"
220
SELECT * from jos_gmaps_icons where icon = "shop.png"
221
SELECT * from jos_gmaps_icons where icon = "shop.png"
222
SELECT * from jos_gmaps_icons where icon = "shop.png"
223
SELECT * from jos_gmaps_icons where icon = "shop.png"
224
SELECT * from jos_gmaps_icons where icon = "shop.png"
225
SELECT * from jos_gmaps_icons where icon = "shop.png"
226
SELECT * from jos_gmaps_icons where icon = "shop.png"
227
SELECT * from jos_gmaps_icons where icon = "shop.png"
228
SELECT * from jos_gmaps_icons where icon = "shop.png"
229
SELECT * from jos_gmaps_icons where icon = "shop.png"
230
SELECT * from jos_gmaps_icons where icon = "shop.png"
231
SELECT * from jos_gmaps_icons where icon = "shop.png"
232
SELECT * from jos_gmaps_icons where icon = "shop.png"
233
SELECT * from jos_gmaps_icons where icon = "shop.png"
234
SELECT * from jos_gmaps_icons where icon = "shop.png"
235
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (12) order by name
236
SELECT * from jos_gmaps_icons where icon = "flower.png"
237
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
238
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
239
SELECT * from jos_gmaps_icons where icon = "waiter.png"
240
SELECT * from jos_gmaps_config
241
SELECT * from jos_gmaps_icons where icon = "default.png"
242
SELECT * from jos_gmaps_icons where icon = "bed.png"
243
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
244
SELECT * from jos_gmaps_config
245
SELECT * from jos_gmaps_icons where icon = "default.png"
246
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
247
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
248
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
249
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Travel Tools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
250
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
251
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'loginmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
252
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
253
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
254
SELECT *
 FROM jos_mambots
 WHERE id = '25'
255
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
256
SELECT *
 FROM jos_mambots
 WHERE id = '23'
257
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
258
SELECT *
 FROM jos_mambots
 WHERE id = '22'
259
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'