Map List

Sign-In

Members

SlideShow Pro

Get the Flash Player to see this player.

329 queries executed
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 < '1280596752' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1280596752' ) AND guest = 1 AND userid = 0 )
3 SELECT * FROM jos_session WHERE session_id = 'a8a491dd3f94a25a6e87a68fe7fa7d46'
4 SELECT session_id FROM jos_session WHERE session_id = '4f1d59425a47a835514cd53f35eb4b61'
5 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '4f1d59425a47a835514cd53f35eb4b61','1280597652','','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 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') <= 20100201 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100201 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100201 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
63 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') <= 20100201) 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, 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') <= 20100202 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100202 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100202 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
65 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') <= 20100202) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
66 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') <= 20100203 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100203 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100203 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
67 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') <= 20100203) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
68 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') <= 20100204 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100204 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100204 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
69 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') <= 20100204) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
70 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='346'
71 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
72 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
73 SELECT * FROM jos_mambots WHERE id = '25'
74 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
75 SELECT * FROM jos_mambots WHERE id = '23'
76 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
77 SELECT * FROM jos_mambots WHERE id = '22'
78 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') <= 20100205 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100205 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100205 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
79 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') <= 20100205) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
80 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='307'
81 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
82 SELECT * FROM jos_mambots WHERE id = '25'
83 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
84 SELECT * FROM jos_mambots WHERE id = '23'
85 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
86 SELECT * FROM jos_mambots WHERE id = '22'
87 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
88 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') <= 20100206 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100206 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100206 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
89 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') <= 20100206) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
90 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='308'
91 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
92 SELECT * FROM jos_mambots WHERE id = '25'
93 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
94 SELECT * FROM jos_mambots WHERE id = '23'
95 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
96 SELECT * FROM jos_mambots WHERE id = '22'
97 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') <= 20100207 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100207 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100207 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
98 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') <= 20100207) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
99 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') <= 20100208 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100208 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100208 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
100 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') <= 20100208) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
101 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') <= 20100209 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100209 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100209 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
102 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') <= 20100209) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' 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') <= 20100210 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100210 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100210 ) ) 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') <= 20100210) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
105 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') <= 20100211 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100211 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100211 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
106 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') <= 20100211) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
107 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') <= 20100212 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100212 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100212 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
108 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') <= 20100212) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
109 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') <= 20100213 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100213 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100213 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
110 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') <= 20100213) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
111 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='343'
112 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
113 SELECT * FROM jos_mambots WHERE id = '25'
114 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
115 SELECT * FROM jos_mambots WHERE id = '23'
116 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
117 SELECT * FROM jos_mambots WHERE id = '22'
118 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='347'
119 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
120 SELECT * FROM jos_mambots WHERE id = '25'
121 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
122 SELECT * FROM jos_mambots WHERE id = '23'
123 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
124 SELECT * FROM jos_mambots WHERE id = '22'
125 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') <= 20100214 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100214 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100214 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
126 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') <= 20100214) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
127 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='343'
128 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
129 SELECT * FROM jos_mambots WHERE id = '25'
130 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
131 SELECT * FROM jos_mambots WHERE id = '23'
132 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
133 SELECT * FROM jos_mambots WHERE id = '22'
134 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='318'
135 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
136 SELECT * FROM jos_mambots WHERE id = '25'
137 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
138 SELECT * FROM jos_mambots WHERE id = '23'
139 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
140 SELECT * FROM jos_mambots WHERE id = '22'
141 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') <= 20100215 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100215 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100215 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
142 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') <= 20100215) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
143 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') <= 20100216 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100216 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100216 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
144 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') <= 20100216) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
145 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') <= 20100217 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100217 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100217 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
146 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') <= 20100217) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
147 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') <= 20100218 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100218 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100218 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
148 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') <= 20100218) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
149 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') <= 20100219 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100219 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100219 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
150 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') <= 20100219) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
151 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') <= 20100220 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100220 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100220 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
152 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') <= 20100220) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
153 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='337'
154 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
155 SELECT * FROM jos_mambots WHERE id = '25'
156 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
157 SELECT * FROM jos_mambots WHERE id = '23'
158 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
159 SELECT * FROM jos_mambots WHERE id = '22'
160 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='344'
161 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
162 SELECT * FROM jos_mambots WHERE id = '25'
163 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
164 SELECT * FROM jos_mambots WHERE id = '23'
165 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
166 SELECT * FROM jos_mambots WHERE id = '22'
167 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') <= 20100221 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100221 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100221 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
168 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') <= 20100221) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
169 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') <= 20100222 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100222 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100222 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
170 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') <= 20100222) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
171 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') <= 20100223 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100223 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100223 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
172 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') <= 20100223) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
173 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') <= 20100224 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100224 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100224 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
174 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') <= 20100224) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
175 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') <= 20100225 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100225 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100225 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
176 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') <= 20100225) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
177 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') <= 20100226 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100226 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100226 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
178 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') <= 20100226) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
179 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') <= 20100227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100227 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
180 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') <= 20100227) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
181 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='345'
182 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
183 SELECT * FROM jos_mambots WHERE id = '25'
184 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
185 SELECT * FROM jos_mambots WHERE id = '23'
186 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
187 SELECT * FROM jos_mambots WHERE id = '22'
188 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') <= 20100228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100228 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
189 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') <= 20100228) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
190 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='378'
191 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
192 SELECT * FROM jos_mambots WHERE id = '25'
193 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
194 SELECT * FROM jos_mambots WHERE id = '23'
195 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
196 SELECT * FROM jos_mambots WHERE id = '22'
197 SELECT cat_id, cat_name, description AS cat_desc, color FROM jos_jcalpro_categories WHERE published = 1 ORDER BY cat_name
198 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'
199 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0 ORDER BY ordering
200 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1'
201 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
202 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND parent>0 AND published='1'
203 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
204 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
205 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
206 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
207 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
208 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
209 SELECT m.* FROM jos_menu AS m WHERE menutype = 'TempDetour' AND published = 1 AND access <= 0 ORDER BY parent, ordering
210 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=38'
211 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
212 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=40'
213 select * from jos_gmaps_maps order by title
214 select * from jos_gmaps_maps order by title
215 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
216 SELECT * from jos_gmaps_icons where icon = "flower.png"
217 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
218 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
219 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
220 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
221 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
222 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
223 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
224 SELECT * from jos_gmaps_icons where icon = "shop.png"
225 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
226 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
227 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
228 SELECT * from jos_gmaps_icons where icon = "shop.png"
229 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
230 SELECT * from jos_gmaps_config
231 SELECT * from jos_gmaps_icons where icon = "default.png"
232 SELECT * from jos_gmaps_icons where icon = "shop.png"
233 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
234 SELECT * from jos_gmaps_config
235 SELECT * from jos_gmaps_icons where icon = "default.png"
236 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
237 SELECT * from jos_gmaps_icons where icon = "shop.png"
238 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
239 SELECT * from jos_gmaps_icons where icon = "bed.png"
240 SELECT * from jos_gmaps_icons where icon = "bed.png"
241 SELECT * from jos_gmaps_icons where icon = "bed.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_icons where icon = "bed.png"
245 SELECT * from jos_gmaps_icons where icon = "bed.png"
246 SELECT * from jos_gmaps_icons where icon = "bed.png"
247 SELECT * from jos_gmaps_icons where icon = "bed.png"
248 SELECT * from jos_gmaps_icons where icon = "bed.png"
249 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
250 SELECT * from jos_gmaps_icons where icon = "bed.png"
251 SELECT * from jos_gmaps_icons where icon = "bed.png"
252 SELECT * from jos_gmaps_icons where icon = "bed.png"
253 SELECT * from jos_gmaps_icons where icon = "bed.png"
254 SELECT * from jos_gmaps_icons where icon = "bed.png"
255 SELECT * from jos_gmaps_icons where icon = "bed.png"
256 SELECT * from jos_gmaps_icons where icon = "bed.png"
257 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
258 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
259 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
260 SELECT * from jos_gmaps_icons where icon = "flower.png"
261 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
262 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
263 SELECT * from jos_gmaps_config
264 SELECT * from jos_gmaps_icons where icon = "default.png"
265 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
266 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
267 SELECT * from jos_gmaps_icons where icon = "flower.png"
268 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
269 SELECT * from jos_gmaps_icons where icon = "hiking.png"
270 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
271 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
272 SELECT * from jos_gmaps_icons where icon = "waiter.png"
273 SELECT * from jos_gmaps_icons where icon = "waiter.png"
274 SELECT * from jos_gmaps_icons where icon = "waiter.png"
275 SELECT * from jos_gmaps_icons where icon = "waiter.png"
276 SELECT * from jos_gmaps_icons where icon = "waiter.png"
277 SELECT * from jos_gmaps_icons where icon = "waiter.png"
278 SELECT * from jos_gmaps_icons where icon = "waiter.png"
279 SELECT * from jos_gmaps_icons where icon = "waiter.png"
280 SELECT * from jos_gmaps_icons where icon = "waiter.png"
281 SELECT * from jos_gmaps_icons where icon = "waiter.png"
282 SELECT * from jos_gmaps_icons where icon = "waiter.png"
283 SELECT * from jos_gmaps_icons where icon = "waiter.png"
284 SELECT * from jos_gmaps_icons where icon = "waiter.png"
285 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
286 SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
287 SELECT * from jos_gmaps_icons where icon = "shop.png"
288 SELECT * from jos_gmaps_icons where icon = "shop.png"
289 SELECT * from jos_gmaps_icons where icon = "shop.png"
290 SELECT * from jos_gmaps_icons where icon = "shop.png"
291 SELECT * from jos_gmaps_icons where icon = "shop.png"
292 SELECT * from jos_gmaps_icons where icon = "shop.png"
293 SELECT * from jos_gmaps_icons where icon = "shop.png"
294 SELECT * from jos_gmaps_icons where icon = "shop.png"
295 SELECT * from jos_gmaps_icons where icon = "shop.png"
296 SELECT * from jos_gmaps_icons where icon = "shop.png"
297 SELECT * from jos_gmaps_icons where icon = "shop.png"
298 SELECT * from jos_gmaps_icons where icon = "shop.png"
299 SELECT * from jos_gmaps_icons where icon = "shop.png"
300 SELECT * from jos_gmaps_icons where icon = "shop.png"
301 SELECT * from jos_gmaps_icons where icon = "shop.png"
302 SELECT * from jos_gmaps_icons where icon = "shop.png"
303 SELECT * from jos_gmaps_icons where icon = "shop.png"
304 SELECT * from jos_gmaps_icons where icon = "shop.png"
305 SELECT * from jos_gmaps_icons where icon = "shop.png"
306 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
307 SELECT * from jos_gmaps_icons where icon = "flower.png"
308 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
309 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
310 SELECT * from jos_gmaps_icons where icon = "waiter.png"
311 SELECT * from jos_gmaps_config
312 SELECT * from jos_gmaps_icons where icon = "default.png"
313 SELECT * from jos_gmaps_icons where icon = "bed.png"
314 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
315 SELECT * from jos_gmaps_config
316 SELECT * from jos_gmaps_icons where icon = "default.png"
317 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
318 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
319 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
320 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Travel Tools' AND published = 1 AND access <= 0 ORDER BY parent, ordering
321 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
322 SELECT m.* FROM jos_menu AS m WHERE menutype = 'loginmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
323 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=14'
324 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
325 SELECT * FROM jos_mambots WHERE id = '25'
326 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
327 SELECT * FROM jos_mambots WHERE id = '23'
328 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
329 SELECT * FROM jos_mambots WHERE id = '22'