Community Login

image
* This Field is required This Field is required | This Field IS visible on profile This Field IS visible on profile | This Field IS NOT visible on profile This Field IS NOT visible on profile | Information for: ? : Field description: Move mouse over icon Field description: Move mouse over icon
Registration
Registration is FREE! Registered users have access to all features at PCShare.Com including ability to create your own blogs, photo/video/music albums, profiles, and many other features.
First Name: * This Field is required This Field IS NOT visible on profile
Last Name: * This Field is required This Field IS NOT visible on profile
Username: * This Field is required This Field IS visible on profile Information for: Username: : Please enter a valid User Name. No spaces, more than 2 characters and contain 0-9,a-z,A-Z
 
E-mail: * This Field is required This Field IS NOT visible on profile Information for: E-mail: : Please enter a valid e-mail address.
Password: * This Field is required This Field IS NOT visible on profile Information for: Password: : Please enter a valid Password. No spaces, more than 6 characters and contain 0-9,a-z,A-Z
Verify Password: * This Field is required This Field IS NOT visible on profile
First Name:
Last Name:
Email:
User Name:
Password: * This Field is required This Field IS NOT visible on profile Information for: Password : _UE_VALID_PASS
Gender: * This Field is required This Field IS visible on profile Information for: Gender : Your gender information is used to assign you an avatar in case you forget to create one. Avatar is a small clipart image representing you, and it can be changed at any time.
Birth Date: * This Field is required This Field IS NOT visible on profile
Company: This Field IS visible on profile
City: This Field IS visible on profile
State: This Field IS visible on profile
Country: This Field IS visible on profile
  Accept Terms and Conditions
Please check your inbox and bulk mail box just incase you don't get the confirmation email.
* This Field is required This Field is required | This Field IS visible on profile This Field IS visible on profile | This Field IS NOT visible on profile This Field IS NOT visible on profile | Information for: ? : Field description: Move mouse over icon Field description: Move mouse over icon
202 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 '%Create an account.html%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'Create-an-account.html' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_comprofiler&Itemid=71&lang=en&task=registers' AND `oldurl` = 'Create-an-account.html'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 71 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1328467974' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328474274' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = '987c6dd56611469187f82910086c453c'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = 'a840be335893abf79d6dea03bf4d664e'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'a840be335893abf79d6dea03bf4d664e','1328475174','','0','1' )
11
SELECT *
 FROM jos_menu
 WHERE id = 71
12
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user'  
 ORDER BY ordering
13
SELECT f.*, t.ordering_register AS tab_ordering_register, t.position AS tab_position, t.ordering AS tab_ordering FROM jos_comprofiler_fields f, jos_comprofiler_tabs t
 WHERE t.tabid = f.tabid AND f.published=1 AND f.registration=1 AND t.enabled=1
 ORDER BY t.ordering_register, t.position, t.ordering, f.ordering
14
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 46
 ORDER BY ordering
15
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 48
 ORDER BY ordering
16
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 50
 ORDER BY ordering
17
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 42
 ORDER BY ordering
18
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 51
 ORDER BY ordering
19
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 57
 ORDER BY ordering
20
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 58
 ORDER BY ordering
21
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 34
 ORDER BY ordering
22
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 35
 ORDER BY ordering
23
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 36
 ORDER BY ordering
24
SELECT fieldtitle FROM jos_comprofiler_field_values
 WHERE fieldid = 38
 ORDER BY ordering
25
SELECT * FROM jos_comprofiler_tabs t
 WHERE t.enabled=1 AND t.pluginclass is not null
 ORDER BY t.ordering_register, t.position, t.ordering
26
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user' AND id IN (512) 
 ORDER BY ordering
27
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user' AND id IN (513) 
 ORDER BY ordering
28
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user' AND id IN (508) 
 ORDER BY ordering
29
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user' AND id IN (510) 
 ORDER BY ordering
30
SELECT id, folder, element, published, type, params, CONCAT_WS('/',folder,element) AS lookup
 FROM jos_comprofiler_plugin
 WHERE published = 1 AND access <= 0 AND type='user' AND id IN (507) 
 ORDER BY ordering
31
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
32
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'
33
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 = 71 )
 ORDER BY ordering
34
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
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 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
44
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
46
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=137&lang=en'
47
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
48
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&lang=en'
49
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&fid=9997&lang=en'
50
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_puarcade&Itemid=117&arcade=leaderboard&lang=en'
51
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=135&lang=en'
52
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&Itemid=140&lang=en'
53
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_jvlinx&Itemid=152&lang=en'
54
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_kunena&Itemid=154&lang=en'
55
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_shared_private_space&Itemid=150&lang=en'
56
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&Itemid=115&lang=en'
57
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=login'
58
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
59
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=lostPassword'
60
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
61
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:52' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:52' )
 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
62
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
63
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
64
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
65
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
66
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
67
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
68
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
69
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
70
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
71
SELECT jlappid FROM jos_jl_app WHERE apphandle='g2bridge'
72
SELECT param, value FROM jos_jl_conf WHERE appid='100'
73
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_gallery2'
 AND published = '1'
 ORDER BY `access`, `parent`, `ordering` ASC
74
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_gallery2&Itemid=82&lang=en'
75
SELECT param, value FROM jos_jl_conf WHERE appid='100'
76
SELECT param, value FROM jos_jl_conf WHERE appid='100'
77
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
78
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
79
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=73'
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_comprofiler&lang=en&task=emailUser&uid=73'
82
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
83
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=73&task=new'
84
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=73
85
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=73&lang=en&task=addConnection'
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_groupjive&groupid=11&lang=en&task=showgroup'
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 = 75
89
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
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=75'
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=75&task=new'
94
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
95
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&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 = 81
98
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=81'
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=81'
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=81&task=new'
103
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=81
104
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=81&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 = 79
107
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=79'
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=79'
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=79&task=new'
112
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=79
113
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=79&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 hideprivate FROM jos_gj_options
116
SELECT a.*, UNIX_TIMESTAMP(a.date_bul) as date_bul, b.type, b.name, e.id_user
FROM jos_gj_bul as a INNER JOIN jos_gj_groups as b
ON a.group_id = b.id
INNER JOIN jos_gj_grcategory AS c
ON b.category = c.id
LEFT JOIN jos_gj_users AS e
ON b.id = e.id_group AND e.id_user = 0
WHERE c.access <=0
ORDER BY a.date_bul DESC LIMIT 4
117
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=12&idm=16&lang=en&task=showfullmessage'
118
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=6&idm=15&lang=en&task=showfullmessage'
119
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=5&idm=14&lang=en&task=showfullmessage'
120
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=7&idm=13&lang=en&task=showfullmessage'
121
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
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 = 89
123
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=89'
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=89'
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=89&task=new'
128
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=89
129
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=89&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 = 100
132
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=100'
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=100'
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=100&task=new'
137
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=100
138
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=100&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 = 118
141
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=118'
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=118'
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=118&task=new'
146
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=118
147
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=118&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 = 153
150
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=153'
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=153'
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=153&task=new'
155
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=153
156
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=153&lang=en&task=addConnection'
157
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
158
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
159
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=95'
160
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
161
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=95'
162
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
163
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=95&task=new'
164
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=95
165
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=95&lang=en&task=addConnection'
166
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
167
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
168
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=102'
169
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
170
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=102'
171
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
172
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=102&task=new'
173
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=102
174
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=102&lang=en&task=addConnection'
175
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
176
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 = 78
177
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=78'
178
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
179
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=78'
180
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
181
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=78&task=new'
182
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=78
183
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=78&lang=en&task=addConnection'
184
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
185
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
186
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=74'
187
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
188
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=74'
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_uddeim&lang=en&recip=74&task=new'
191
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=74
192
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=74&lang=en&task=addConnection'
193
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
194
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
195
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=172'
196
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
197
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=172'
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_uddeim&lang=en&recip=172&task=new'
200
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=172
201
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=172&lang=en&task=addConnection'
202
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'