Map List

Sign-In

Members

SlideShow Pro

Get the Flash Player to see this player.

252 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 < '1280596225' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1280596225' ) AND guest = 1 AND userid = 0 )
3 SELECT * FROM jos_session WHERE session_id = '26c7af44be96f2e94516a08b73e3f738'
4 SELECT session_id FROM jos_session WHERE session_id = '39aeb5857471712dbc01690bf694abaa'
5 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '39aeb5857471712dbc01690bf694abaa','1280597125','','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') <= 20091227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091227) 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') <= 20091227 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091227 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20091227 ) ) 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') <= 20091227) 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='310'
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') <= 20091228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091228) 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') <= 20091228 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091228 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20091228 ) ) 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') <= 20091228) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
76 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='310'
77 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
78 SELECT * FROM jos_mambots WHERE id = '25'
79 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
80 SELECT * FROM jos_mambots WHERE id = '23'
81 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
82 SELECT * FROM jos_mambots WHERE id = '22'
83 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') <= 20091229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091229) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
84 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') <= 20091229 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091229 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20091229 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
85 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') <= 20091229) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
86 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='310'
87 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
88 SELECT * FROM jos_mambots WHERE id = '25'
89 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
90 SELECT * FROM jos_mambots WHERE id = '23'
91 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
92 SELECT * FROM jos_mambots WHERE id = '22'
93 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') <= 20091230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091230) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
94 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') <= 20091230 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091230 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20091230 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
95 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') <= 20091230) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
96 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='310'
97 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
98 SELECT * FROM jos_mambots WHERE id = '25'
99 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
100 SELECT * FROM jos_mambots WHERE id = '23'
101 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
102 SELECT * FROM jos_mambots WHERE id = '22'
103 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') <= 20091231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091231) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
104 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') <= 20091231 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20091231 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20091231 ) ) 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, 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') <= 20091231) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
106 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='310'
107 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
108 SELECT * FROM jos_mambots WHERE id = '25'
109 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
110 SELECT * FROM jos_mambots WHERE id = '23'
111 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
112 SELECT * FROM jos_mambots WHERE id = '22'
113 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') <= 20100101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100101) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
114 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') <= 20100101 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100101 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100101 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
115 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') <= 20100101) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
116 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') <= 20100102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100102) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
117 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') <= 20100102 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100102 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100102 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
118 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') <= 20100102) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
119 SELECT cat_id, cat_name, description AS cat_desc, color FROM jos_jcalpro_categories WHERE published = 1 ORDER BY cat_name
120 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'
121 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0 ORDER BY ordering
122 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1'
123 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
124 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND parent>0 AND published='1'
125 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
126 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
127 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
128 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
129 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
130 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
131 SELECT m.* FROM jos_menu AS m WHERE menutype = 'TempDetour' AND published = 1 AND access <= 0 ORDER BY parent, ordering
132 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=38'
133 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
134 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=40'
135 select * from jos_gmaps_maps order by title
136 select * from jos_gmaps_maps order by title
137 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
138 SELECT * from jos_gmaps_icons where icon = "flower.png"
139 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
140 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
141 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
142 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
143 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
144 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
145 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
146 SELECT * from jos_gmaps_icons where icon = "shop.png"
147 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
148 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
149 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
150 SELECT * from jos_gmaps_icons where icon = "shop.png"
151 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
152 SELECT * from jos_gmaps_config
153 SELECT * from jos_gmaps_icons where icon = "default.png"
154 SELECT * from jos_gmaps_icons where icon = "shop.png"
155 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
156 SELECT * from jos_gmaps_config
157 SELECT * from jos_gmaps_icons where icon = "default.png"
158 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
159 SELECT * from jos_gmaps_icons where icon = "shop.png"
160 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
161 SELECT * from jos_gmaps_icons where icon = "bed.png"
162 SELECT * from jos_gmaps_icons where icon = "bed.png"
163 SELECT * from jos_gmaps_icons where icon = "bed.png"
164 SELECT * from jos_gmaps_icons where icon = "bed.png"
165 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
166 SELECT * from jos_gmaps_icons where icon = "bed.png"
167 SELECT * from jos_gmaps_icons where icon = "bed.png"
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 = "icon_house.png"
172 SELECT * from jos_gmaps_icons where icon = "bed.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 = "bed.png"
179 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
180 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
181 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
182 SELECT * from jos_gmaps_icons where icon = "flower.png"
183 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
184 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
185 SELECT * from jos_gmaps_config
186 SELECT * from jos_gmaps_icons where icon = "default.png"
187 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
188 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
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 = "hiking.png"
192 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
193 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
194 SELECT * from jos_gmaps_icons where icon = "waiter.png"
195 SELECT * from jos_gmaps_icons where icon = "waiter.png"
196 SELECT * from jos_gmaps_icons where icon = "waiter.png"
197 SELECT * from jos_gmaps_icons where icon = "waiter.png"
198 SELECT * from jos_gmaps_icons where icon = "waiter.png"
199 SELECT * from jos_gmaps_icons where icon = "waiter.png"
200 SELECT * from jos_gmaps_icons where icon = "waiter.png"
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 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
208 SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
209 SELECT * from jos_gmaps_icons where icon = "shop.png"
210 SELECT * from jos_gmaps_icons where icon = "shop.png"
211 SELECT * from jos_gmaps_icons where icon = "shop.png"
212 SELECT * from jos_gmaps_icons where icon = "shop.png"
213 SELECT * from jos_gmaps_icons where icon = "shop.png"
214 SELECT * from jos_gmaps_icons where icon = "shop.png"
215 SELECT * from jos_gmaps_icons where icon = "shop.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 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
229 SELECT * from jos_gmaps_icons where icon = "flower.png"
230 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
231 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
232 SELECT * from jos_gmaps_icons where icon = "waiter.png"
233 SELECT * from jos_gmaps_config
234 SELECT * from jos_gmaps_icons where icon = "default.png"
235 SELECT * from jos_gmaps_icons where icon = "bed.png"
236 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
237 SELECT * from jos_gmaps_config
238 SELECT * from jos_gmaps_icons where icon = "default.png"
239 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
240 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
241 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
242 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Travel Tools' AND published = 1 AND access <= 0 ORDER BY parent, ordering
243 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
244 SELECT m.* FROM jos_menu AS m WHERE menutype = 'loginmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
245 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=14'
246 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
247 SELECT * FROM jos_mambots WHERE id = '25'
248 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
249 SELECT * FROM jos_mambots WHERE id = '23'
250 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
251 SELECT * FROM jos_mambots WHERE id = '22'
252 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'