157 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%component%') AND (`published` > 0))
4
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
5
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
6
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
7
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 82 )
 ORDER BY menuid DESC
LIMIT 1
8
DELETE FROM jos_session
 WHERE (
 ( time < '1328468247' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328474547' )
 AND guest = 1
 AND userid = 0
 )
9
SELECT *
 FROM jos_session
 WHERE session_id = '25b95e8a17f2038cad52de7b6924d4f1'
10
SELECT session_id
 FROM jos_session
 WHERE session_id = '824e128f132f9444fe7772e57a9540d2'
11
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '824e128f132f9444fe7772e57a9540d2','1328475447','','0','1' )
12
SELECT *
 FROM jos_menu
 WHERE id = 82
13
SELECT *
 FROM jos_menu
 WHERE id = '82'
14
SELECT jlappid FROM jos_jl_app WHERE apphandle='g2bridge'
15
SELECT param, value FROM jos_jl_conf WHERE appid='100'
16
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_gallery2'
 AND published = '1'
 ORDER BY `access`, `parent`, `ordering` ASC
17
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
18
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
19
SELECT param, value FROM jos_jl_conf WHERE appid='100'
20
SELECT param, value FROM jos_jl_conf WHERE appid='100'
21
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'
22
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 = 82 )
 ORDER BY ordering
23
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
24
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
25
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
26
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
29
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
31
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
32
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
33
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
34
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
35
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
36
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
37
SELECT u.id, u.username, u.name, c.avatar FROM jos_comprofiler c, jos_users u where c.id = u.id  and c.avatar IS NOT NULL and c.approved = 1 and c.confirmed = 1 and u.block = 0 and c.banned = 0 group by u.id order by c.hits desc limit 4
38
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 73
39
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
40
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
41
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=73'
42
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
43
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=73&task=new'
44
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=73
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&lang=en&task=addConnection'
46
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
47
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=11&lang=en&task=showgroup'
48
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 75
49
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
50
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
51
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
52
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
53
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=75&task=new'
54
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
55
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
56
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
57
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 81
58
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
59
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
60
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=81'
61
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
62
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=81&task=new'
63
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=81
64
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&lang=en&task=addConnection'
65
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
66
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 79
67
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
68
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
69
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
70
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
71
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
72
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
73
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
74
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
75
select u.id, u.username, u.name, c.avatar from jos_users u, jos_comprofiler c where u.id = c.user_id and c.approved = 1 and c.confirmed = 1  and c.avatar IS NOT NULL and c.banned = 0 and u.block = 0 order by rand() desc limit 9
76
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 95
77
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=95'
78
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
79
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=95'
80
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
81
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=95&task=new'
82
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=95
83
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=95&lang=en&task=addConnection'
84
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
85
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 174
86
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=174'
87
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
88
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=174'
89
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
90
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=174&task=new'
91
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=174
92
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=174&lang=en&task=addConnection'
93
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
94
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 125
95
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=125'
96
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
97
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=125'
98
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
99
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=125&task=new'
100
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=125
101
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=125&lang=en&task=addConnection'
102
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
103
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 62
104
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=62'
105
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
106
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=62'
107
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
108
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=62&task=new'
109
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=62
110
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=62&lang=en&task=addConnection'
111
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
112
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=4&lang=en&task=showgroup'
113
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 153
114
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=153'
115
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
116
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=153'
117
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
118
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=153&task=new'
119
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=153
120
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=153&lang=en&task=addConnection'
121
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
122
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 79
123
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
124
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
125
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
126
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
127
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
128
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
129
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
130
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
131
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 165
132
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=165'
133
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
134
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=165'
135
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
136
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=165&task=new'
137
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=165
138
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=165&lang=en&task=addConnection'
139
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
140
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 94
141
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=94'
142
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
143
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=94'
144
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
145
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=94&task=new'
146
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=94
147
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=94&lang=en&task=addConnection'
148
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
149
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 164
150
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=164'
151
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
152
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=164'
153
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
154
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=164&task=new'
155
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=164
156
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=164&lang=en&task=addConnection'
157
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'