212 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_puarcade&Itemid=117&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_puarcade&Itemid=117&lang=en'
7 SELECT template FROM jos_templates_menu WHERE client_id = 0 AND ( menuid = 0 OR menuid = 117 ) ORDER BY menuid DESC LIMIT 1
8 DELETE FROM jos_session WHERE ( ( time < '1328468292' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1328474592' ) AND guest = 1 AND userid = 0 )
9 SELECT * FROM jos_session WHERE session_id = '98b5b447a8fbe7f5112a59e0d3b1ae39'
10 SELECT session_id FROM jos_session WHERE session_id = 'd7399f3d20bdaca6076ac85e9bbeba85'
11 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'd7399f3d20bdaca6076ac85e9bbeba85','1328475492','','0','1' )
12 SELECT * FROM jos_menu WHERE id = 117
13 SELECT * FROM jos_puarcade_config WHERE id = '1'
14 SELECT * FROM jos_puarcade_config WHERE id = '1'
15 SELECT parentid FROM jos_puarcade_folders WHERE id = ''
16 SELECT parentid FROM jos_puarcade_folders WHERE id = ''
17 SELECT name from jos_puarcade_folders where id = ''
18 SELECT * FROM jos_puarcade_config WHERE id = '1'
19 SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
20 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
21 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9998&lang=en'
22 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
23 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
24 SELECT * FROM jos_puarcade_config WHERE id = '1'
25 SELECT f.id,f.name,f.description,f.imagename,f.parentid from jos_puarcade_folders AS f where f.published = '1' AND f.parentid = 0 ORDER BY f.name
26 SELECT id,numplayed,description,imagename,published,gamename,title,reverse_score,scoring,numplayed,window FROM jos_puarcade_games WHERE published = '1' AND folderid = '1' ORDER BY rand() LIMIT 3
27 SELECT count(*) FROM jos_puarcade_games WHERE published = '1' AND folderid = '1'
28 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&lang=en'
29 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&lang=en'
30 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '16' AND published = '1' ORDER BY score desc LIMIT 1
31 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=16&lang=en'
32 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=16&lang=en'
33 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '1' AND published = '1' ORDER BY score desc LIMIT 1
34 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=scores&gname=neave_frogger&lang=en'
35 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=1&lang=en'
36 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=1&lang=en'
37 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '8' AND published = '1' ORDER BY score desc LIMIT 1
38 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=8&lang=en'
39 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&gid=8&lang=en'
40 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=1&lang=en'
41 SELECT id,numplayed,description,imagename,published,gamename,title,reverse_score,scoring,numplayed,window FROM jos_puarcade_games WHERE published = '1' AND folderid = '2' ORDER BY rand() LIMIT 3
42 SELECT count(*) FROM jos_puarcade_games WHERE published = '1' AND folderid = '2'
43 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&lang=en'
44 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&lang=en'
45 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '19' AND published = '1' ORDER BY score desc LIMIT 1
46 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=scores&gname=scrabblastGC&lang=en'
47 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=19&lang=en'
48 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=19&lang=en'
49 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '22' AND published = '1' ORDER BY score desc LIMIT 1
50 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=scores&gname=numbers&lang=en'
51 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=22&lang=en'
52 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=22&lang=en'
53 Select jos_puarcade.score,jos_puarcade.userid,jos_users.name,jos_users.username from jos_puarcade left join jos_users on (jos_puarcade.userid = jos_users.id) WHERE gameid LIKE '20' AND published = '1' ORDER BY score desc LIMIT 1
54 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=scores&gname=bookwormSte&lang=en'
55 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=20&lang=en'
56 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&gid=20&lang=en'
57 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=2&lang=en'
58 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'
59 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 = 117 ) ORDER BY ordering
60 SELECT folder, element, published, params FROM jos_mambots WHERE access <= 0 AND folder = 'content' ORDER BY ordering
61 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
62 SELECT * FROM jos_mambots WHERE id = '32'
63 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
64 SELECT * FROM jos_mambots WHERE id = '32'
65 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
66 SELECT * FROM jos_mambots WHERE id = '32'
67 SELECT id FROM jos_mambots WHERE element = 'plugin_jw_allvideos' AND folder = 'content'
68 SELECT * FROM jos_mambots WHERE id = '32'
69 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
70 SELECT m.* FROM jos_menu AS m WHERE menutype='mainmenu' AND m.published='1'
71 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
72 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
73 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
74 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
75 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
76 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
77 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
78 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
79 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
80 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
81 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
82 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
83 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
84 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
85 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
86 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
87 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=73'
88 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
89 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=73&task=new'
90 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=73
91 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&lang=en&task=addConnection'
92 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
93 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=11&lang=en&task=showgroup'
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 = 75
95 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
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=75'
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=75&task=new'
100 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=75
101 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&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 = 81
104 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
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=81'
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=81&task=new'
109 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=81
110 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&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 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
113 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
114 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
115 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
116 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
117 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
118 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=79
119 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
120 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
121 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:58' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:58' ) 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
122 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
123 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
124 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
125 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
126 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
127 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
128 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
129 SELECT id FROM jos_menu WHERE type = 'content_blog_section' AND published = 1 AND componentid = 0
130 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
131 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
132 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 = 77
133 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=77'
134 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
135 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=77'
136 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
137 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=77&task=new'
138 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=77
139 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=77&lang=en&task=addConnection'
140 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
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 = 106
142 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=106'
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=106'
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=106&task=new'
147 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=106
148 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=106&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 = 75
151 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
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=75'
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=75&task=new'
156 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=75
157 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&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 = 102
160 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=102'
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=102'
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=102&task=new'
165 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=102
166 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=102&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 s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 99
169 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=99'
170 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
171 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=99'
172 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
173 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=99&task=new'
174 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=99
175 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=99&lang=en&task=addConnection'
176 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
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 = 74
178 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=74'
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=74'
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=74&task=new'
183 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=74
184 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=74&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 s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 90
187 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=90'
188 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
189 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=90'
190 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
191 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=90&task=new'
192 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=90
193 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=90&lang=en&task=addConnection'
194 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
195 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 = 89
196 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=89'
197 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
198 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=89'
199 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
200 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=89&task=new'
201 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=89
202 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=89&lang=en&task=addConnection'
203 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
204 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 = 93
205 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=93'
206 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
207 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=93'
208 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
209 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=93&task=new'
210 select a.* FROM jos_comprofiler_members a WHERE a.referenceid=0 and a.memberid=93
211 SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=93&lang=en&task=addConnection'
212 SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'