Quote this article on your site

The MailMan's Last Day

To create link towards this article on your website,
copy and paste the text below in your page.



Preview :

The MailMan's Last Day
PCShare.Com - Thursday, 09 February 2012
2012 © PCShare.Com

Go back to the article
151 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_akocomment&Itemid=102&id=123&lang=en&task=quote'
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_akocomment&Itemid=102&id=123&lang=en&task=quote'
7
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 102 )
 ORDER BY menuid DESC
LIMIT 1
8
DELETE FROM jos_session
 WHERE (
 ( time < '1328785502' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328791802' )
 AND guest = 1
 AND userid = 0
 )
9
SELECT *
 FROM jos_session
 WHERE session_id = 'ed251f3087e7fb74167e86cef9336866'
10
SELECT session_id
 FROM jos_session
 WHERE session_id = '3556894cf9cdcde4395373d5124cdef5'
11
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '3556894cf9cdcde4395373d5124cdef5','1328792702','','0','1' )
12
SELECT *
 FROM jos_menu
 WHERE id = 102
13
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
14
SELECT title FROM jos_content WHERE id = '123'
15
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'
16
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
17
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
18
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
19
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
20
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
21
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
22
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
23
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
24
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
25
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
26
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
29
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
31
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
32
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
33
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
34
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
35
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
36
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
37
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=75&task=new'
38
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
39
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
40
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
41
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
42
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
43
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
44
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=73'
45
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
46
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=73&task=new'
47
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=73
48
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&lang=en&task=addConnection'
49
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
50
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=11&lang=en&task=showgroup'
51
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
52
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
53
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
54
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=81'
55
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
56
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=81&task=new'
57
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=81
58
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&lang=en&task=addConnection'
59
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
60
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
61
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
62
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
63
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=79'
64
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
65
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=79&task=new'
66
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
67
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&lang=en&task=addConnection'
68
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
69
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
70
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
71
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=77'
72
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
73
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=77'
74
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
75
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=77&task=new'
76
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=77
77
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=77&lang=en&task=addConnection'
78
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
79
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
80
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=96'
81
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
82
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=96'
83
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
84
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=96&task=new'
85
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=96
86
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=96&lang=en&task=addConnection'
87
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
88
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 = 109
89
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=109'
90
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
91
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=109'
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_uddeim&lang=en&recip=109&task=new'
94
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=109
95
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=109&lang=en&task=addConnection'
96
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
97
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
98
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=100'
99
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
100
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=100'
101
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=100&task=new'
103
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=100
104
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=100&lang=en&task=addConnection'
105
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
106
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 = 104
107
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=104'
108
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
109
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=104'
110
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
111
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=104&task=new'
112
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=104
113
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=104&lang=en&task=addConnection'
114
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
115
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
116
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=76'
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_comprofiler&lang=en&task=emailUser&uid=76'
119
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
120
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=76&task=new'
121
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=76
122
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=76&lang=en&task=addConnection'
123
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
124
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=13&lang=en&task=showgroup'
125
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 = 108
126
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=108'
127
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
128
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=108'
129
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
130
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=108&task=new'
131
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=108
132
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=108&lang=en&task=addConnection'
133
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
134
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
135
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=99'
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_comprofiler&lang=en&task=emailUser&uid=99'
138
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
139
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=99&task=new'
140
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=99
141
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=99&lang=en&task=addConnection'
142
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
143
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 = 103
144
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=103'
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_comprofiler&lang=en&task=emailUser&uid=103'
147
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
148
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=103&task=new'
149
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=103
150
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=103&lang=en&task=addConnection'
151
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'