Map List

Sign-In

Members

SlideShow Pro

Get the Flash Player to see this player.

245 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 < '1280596895' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1280596895' ) AND guest = 1 AND userid = 0 )
3 SELECT * FROM jos_session WHERE session_id = '07fd4de804648dae351b3ce5b90282a9'
4 SELECT session_id FROM jos_session WHERE session_id = 'df7cbbdd47de48a200088c321bbbaf65'
5 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'df7cbbdd47de48a200088c321bbbaf65','1280597795','','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') <= 20100110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100110) 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') <= 20100110 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100110 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100110 ) ) 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') <= 20100110) 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='317'
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 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='336'
74 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
75 SELECT * FROM jos_mambots WHERE id = '25'
76 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
77 SELECT * FROM jos_mambots WHERE id = '23'
78 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
79 SELECT * FROM jos_mambots WHERE id = '22'
80 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') <= 20100111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100111) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
81 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') <= 20100111 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100111 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100111 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
82 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') <= 20100111) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
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') <= 20100112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100112) 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') <= 20100112 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100112 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100112 ) ) 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') <= 20100112) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
86 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') <= 20100113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100113) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
87 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') <= 20100113 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100113 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100113 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
88 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') <= 20100113) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
89 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') <= 20100114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100114) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
90 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') <= 20100114 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100114 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100114 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
91 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') <= 20100114) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
92 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') <= 20100115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100115) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
93 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') <= 20100115 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100115 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100115 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
94 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') <= 20100115) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
95 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') <= 20100116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100116) AND c.published = '1' AND approved='1' ORDER BY start_date,title ASC
96 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') <= 20100116 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100116 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100116 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
97 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') <= 20100116) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> '' ORDER BY start_date,title ASC
98 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='331'
99 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
100 SELECT * FROM jos_mambots WHERE id = '25'
101 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
102 SELECT * FROM jos_mambots WHERE id = '23'
103 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
104 SELECT * FROM jos_mambots WHERE id = '22'
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='332'
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 cat_id, cat_name, description AS cat_desc, color FROM jos_jcalpro_categories WHERE published = 1 ORDER BY cat_name
113 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'
114 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0 ORDER BY ordering
115 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1'
116 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
117 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND parent>0 AND published='1'
118 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
119 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
120 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
121 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
122 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
123 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
124 SELECT m.* FROM jos_menu AS m WHERE menutype = 'TempDetour' AND published = 1 AND access <= 0 ORDER BY parent, ordering
125 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=38'
126 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
127 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=40'
128 select * from jos_gmaps_maps order by title
129 select * from jos_gmaps_maps order by title
130 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
131 SELECT * from jos_gmaps_icons where icon = "flower.png"
132 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
133 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
134 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
135 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
136 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
137 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
138 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
139 SELECT * from jos_gmaps_icons where icon = "shop.png"
140 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
141 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
142 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
143 SELECT * from jos_gmaps_icons where icon = "shop.png"
144 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
145 SELECT * from jos_gmaps_config
146 SELECT * from jos_gmaps_icons where icon = "default.png"
147 SELECT * from jos_gmaps_icons where icon = "shop.png"
148 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
149 SELECT * from jos_gmaps_config
150 SELECT * from jos_gmaps_icons where icon = "default.png"
151 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
152 SELECT * from jos_gmaps_icons where icon = "shop.png"
153 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
154 SELECT * from jos_gmaps_icons where icon = "bed.png"
155 SELECT * from jos_gmaps_icons where icon = "bed.png"
156 SELECT * from jos_gmaps_icons where icon = "bed.png"
157 SELECT * from jos_gmaps_icons where icon = "bed.png"
158 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
159 SELECT * from jos_gmaps_icons where icon = "bed.png"
160 SELECT * from jos_gmaps_icons where icon = "bed.png"
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 = "icon_house.png"
165 SELECT * from jos_gmaps_icons where icon = "bed.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 = "bed.png"
172 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
173 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
174 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
175 SELECT * from jos_gmaps_icons where icon = "flower.png"
176 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
177 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
178 SELECT * from jos_gmaps_config
179 SELECT * from jos_gmaps_icons where icon = "default.png"
180 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
181 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
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 = "hiking.png"
185 SELECT * from jos_gmaps_icons where icon = "blue-marker.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 (8) order by name
187 SELECT * from jos_gmaps_icons where icon = "waiter.png"
188 SELECT * from jos_gmaps_icons where icon = "waiter.png"
189 SELECT * from jos_gmaps_icons where icon = "waiter.png"
190 SELECT * from jos_gmaps_icons where icon = "waiter.png"
191 SELECT * from jos_gmaps_icons where icon = "waiter.png"
192 SELECT * from jos_gmaps_icons where icon = "waiter.png"
193 SELECT * from jos_gmaps_icons where icon = "waiter.png"
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 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
201 SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
202 SELECT * from jos_gmaps_icons where icon = "shop.png"
203 SELECT * from jos_gmaps_icons where icon = "shop.png"
204 SELECT * from jos_gmaps_icons where icon = "shop.png"
205 SELECT * from jos_gmaps_icons where icon = "shop.png"
206 SELECT * from jos_gmaps_icons where icon = "shop.png"
207 SELECT * from jos_gmaps_icons where icon = "shop.png"
208 SELECT * from jos_gmaps_icons where icon = "shop.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 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
222 SELECT * from jos_gmaps_icons where icon = "flower.png"
223 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
224 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
225 SELECT * from jos_gmaps_icons where icon = "waiter.png"
226 SELECT * from jos_gmaps_config
227 SELECT * from jos_gmaps_icons where icon = "default.png"
228 SELECT * from jos_gmaps_icons where icon = "bed.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 = "green-marker.png"
233 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
234 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
235 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Travel Tools' AND published = 1 AND access <= 0 ORDER BY parent, ordering
236 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
237 SELECT m.* FROM jos_menu AS m WHERE menutype = 'loginmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
238 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=14'
239 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
240 SELECT * FROM jos_mambots WHERE id = '25'
241 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
242 SELECT * FROM jos_mambots WHERE id = '23'
243 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
244 SELECT * FROM jos_mambots WHERE id = '22'
245 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'