258 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 '%Mamblog%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Mamblog/Comedy/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=102&id=23&lang=en&limit=9&limitstart=0&task=blogcategory' AND `oldurl` = 'Mamblog/Comedy/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 102 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1328467286' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328473586' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = 'a8060e708485144e3dd97c52b199a3f4'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = '08f09bfba077306365361a22836aa429'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '08f09bfba077306365361a22836aa429','1328474486','','0','1' )
11
SELECT *
 FROM jos_menu
 WHERE id = 102
12
SELECT COUNT(a.id)
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-05 14:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:41' )
 AND ( a.catid=23 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
13
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access,
 CHAR_LENGTH( a.fulltext ) AS readmore, s.published AS sec_pub,  cc.published AS sec_pub, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_sections AS s ON a.sectionid = s.id
 LEFT JOIN jos_groups AS g ON a.access = g.id
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-05 14:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:41' )
 AND ( a.catid=23 )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  a.created DESC
LIMIT 9
14
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 135
15
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
16
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
17
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
18
SELECT *
 FROM jos_mambots
 WHERE id = '32'
19
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
20
SELECT *
 FROM jos_mambots
 WHERE id = '32'
21
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
22
SELECT *
 FROM jos_mambots
 WHERE id = '32'
23
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
24
SELECT *
 FROM jos_mambots
 WHERE id = '32'
25
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 135
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
26
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '135'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=135&lang=en&task=favoured'
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=135&lang=en&task=quote'
29
SELECT hits FROM jos_content WHERE id = '135'
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=135&lang=en&task=view'
31
SELECT title_alias,id FROM jos_content WHERE id=135
32
SELECT s.title AS section,s.id AS secid,  c.title AS category,c.id AS catid,  a.title AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=135
33
SELECT count(*) FROM jos_akocomment WHERE contentid='135' AND published='1'
34
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 128
35
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
36
SELECT *
 FROM jos_mambots
 WHERE id = '32'
37
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
38
SELECT *
 FROM jos_mambots
 WHERE id = '32'
39
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
40
SELECT *
 FROM jos_mambots
 WHERE id = '32'
41
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
42
SELECT *
 FROM jos_mambots
 WHERE id = '32'
43
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 128
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '128'
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=128&lang=en&task=favoured'
46
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=128&lang=en&task=quote'
47
SELECT hits FROM jos_content WHERE id = '128'
48
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=128&lang=en&task=view'
49
SELECT title_alias,id FROM jos_content WHERE id=128
50
SELECT s.title AS section,s.id AS secid,  c.title AS category,c.id AS catid,  a.title AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=128
51
SELECT count(*) FROM jos_akocomment WHERE contentid='128' AND published='1'
52
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 126
53
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
54
SELECT *
 FROM jos_mambots
 WHERE id = '32'
55
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
56
SELECT *
 FROM jos_mambots
 WHERE id = '32'
57
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
58
SELECT *
 FROM jos_mambots
 WHERE id = '32'
59
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
60
SELECT *
 FROM jos_mambots
 WHERE id = '32'
61
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 126
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
62
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '126'
63
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=126&lang=en&task=favoured'
64
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=126&lang=en&task=quote'
65
SELECT hits FROM jos_content WHERE id = '126'
66
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=126&lang=en&task=view'
67
SELECT title_alias,id FROM jos_content WHERE id=126
68
SELECT s.title AS section,s.id AS secid,  c.title AS category,c.id AS catid,  a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=126
69
SELECT count(*) FROM jos_akocomment WHERE contentid='126' AND published='1'
70
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 124
71
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
72
SELECT *
 FROM jos_mambots
 WHERE id = '32'
73
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
74
SELECT *
 FROM jos_mambots
 WHERE id = '32'
75
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
76
SELECT *
 FROM jos_mambots
 WHERE id = '32'
77
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
78
SELECT *
 FROM jos_mambots
 WHERE id = '32'
79
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 124
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
80
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '124'
81
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=124&lang=en&task=favoured'
82
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=124&lang=en&task=quote'
83
SELECT hits FROM jos_content WHERE id = '124'
84
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=124&lang=en&task=view'
85
SELECT title_alias,id FROM jos_content WHERE id=124
86
SELECT s.title AS section,s.id AS secid,  c.title AS category,c.id AS catid,  a.title AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=124
87
SELECT count(*) FROM jos_akocomment WHERE contentid='124' AND published='1'
88
SELECT ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
 FROM jos_content AS a
 LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
 WHERE a.id = 123
89
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
90
SELECT *
 FROM jos_mambots
 WHERE id = '32'
91
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
92
SELECT *
 FROM jos_mambots
 WHERE id = '32'
93
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
94
SELECT *
 FROM jos_mambots
 WHERE id = '32'
95
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
96
SELECT *
 FROM jos_mambots
 WHERE id = '32'
97
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 123
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
98
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '123'
99
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=123&lang=en&task=favoured'
100
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=123&lang=en&task=quote'
101
SELECT hits FROM jos_content WHERE id = '123'
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=123&lang=en&task=view'
103
SELECT title_alias,id FROM jos_content WHERE id=123
104
SELECT s.title AS section,s.id AS secid,  c.title AS category,c.id AS catid,  a.title_alias AS title,a.id as id FROM jos_content as a LEFT JOIN jos_sections AS s ON a.sectionid=s.id LEFT JOIN jos_categories AS c ON a.catid=c.id WHERE a.id=123
105
SELECT count(*) FROM jos_akocomment WHERE contentid='123' AND published='1'
106
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'
107
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 = 102 )
 ORDER BY ordering
108
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
109
SELECT *
 FROM jos_mambots
 WHERE id = '32'
110
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
111
SELECT *
 FROM jos_mambots
 WHERE id = '32'
112
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
113
SELECT *
 FROM jos_mambots
 WHERE id = '32'
114
SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
115
SELECT *
 FROM jos_mambots
 WHERE id = '32'
116
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
117
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
118
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
119
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
120
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
121
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
122
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
123
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
124
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
125
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
126
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
127
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
128
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
129
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
130
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
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 = 73
132
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
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=73'
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=73&task=new'
137
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=73
138
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&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 oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=11&lang=en&task=showgroup'
141
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
142
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
143
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
144
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
145
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
146
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=75&task=new'
147
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
148
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
149
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
150
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
151
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
152
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
153
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=81'
154
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
155
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=81&task=new'
156
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=81
157
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&lang=en&task=addConnection'
158
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
159
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
160
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
161
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
162
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
163
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
164
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
165
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
166
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
167
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
168
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-05 14:41' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:41' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND f.content_id IS NULL
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 8
169
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 136
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
170
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 134
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
171
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 133
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
172
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 131
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
173
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 130
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
174
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 129
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
175
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
176
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
177
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 = 76
178
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=76'
179
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
180
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=76'
181
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
182
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=76&task=new'
183
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=76
184
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=76&lang=en&task=addConnection'
185
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
186
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=13&lang=en&task=showgroup'
187
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 = 100
188
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=100'
189
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
190
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=100'
191
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
192
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=100&task=new'
193
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=100
194
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=100&lang=en&task=addConnection'
195
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
196
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 = 96
197
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=96'
198
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
199
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=96'
200
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
201
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=96&task=new'
202
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=96
203
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=96&lang=en&task=addConnection'
204
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
205
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
206
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=153'
207
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
208
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=153'
209
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
210
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=153&task=new'
211
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=153
212
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=153&lang=en&task=addConnection'
213
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
214
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 = 172
215
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=172'
216
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
217
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=172'
218
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
219
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=172&task=new'
220
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=172
221
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=172&lang=en&task=addConnection'
222
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
223
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
224
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
225
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
226
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
227
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
228
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=75&task=new'
229
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
230
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
231
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
232
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 = 97
233
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=97'
234
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
235
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=97'
236
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
237
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=97&task=new'
238
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=97
239
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=97&lang=en&task=addConnection'
240
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
241
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
242
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=165'
243
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
244
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=165'
245
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
246
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=165&task=new'
247
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=165
248
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=165&lang=en&task=addConnection'
249
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
250
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
251
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
252
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
253
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
254
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
255
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
256
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
257
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
258
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'