• Home
• Photo Albums
  • All Albums
• Games
  • All Games
  • Newest Games
  • Most Popular Games
  • Leading Players
• Blogs
  • Comedy
  • Health
  • Education
  • Movies & Music
  • General
  • All Blogs
  • - - - - - - -
• News
  • Health/Wellness
  • Education
  • Food/Recipes
  • Technology & Innovations
• Private Groups
  • List All Groups
  • Create Your Own Group
  • Link Directory
• Forums
• Community
  • My Profile
  • File Share
  • Write New Blog
  • Private Messages
• Help
  • Search
  • FAQ
  • Terms and Conditions
  • Contact Us
  • Useful Links

Most Popular Users felix hanah KaseyK skullz Latest Blogs Denzel Washington - The True American Ocean View Restaurant Must Read for All Texans, Used-To-Be Texans, Adopted Texans, or Wanna-B Texans What are those annoying AlbumArt files cluttering my hard drive? The Smart Cars Law of the Garbage Truck How to Fix Social Security Drinking with a Texas Girl

Blogs Denzel Washington - The True American User Rating: / 0 Written by Felix the Great!    Friday, 08 October 2010 Be first to comment this article | Add as favourites (81) | Quote this article on your site | Views: 1085 | Read more... Read more...   Ocean View Restaurant User Rating: / 0 Written by Felix the Great!    Thursday, 06 May 2010 Be first to comment this article | Add as favourites (104) | Quote this article on your site | Views: 1470 | Read more... Read more...   Must Read for All Texans, Used-To-Be Texans, Adopted Texans, or Wanna-B Texans User Rating: / 2 Written by Felix the Great!    Wednesday, 03 March 2010 Be first to comment this article | Add as favourites (124) | Quote this article on your site | Views: 1327 | Read more... Read more...   What are those annoying AlbumArt files cluttering my hard drive? User Rating: / 1 Written by Felix the Great!    Saturday, 14 November 2009 Be first to comment this article | Add as favourites (146) | Quote this article on your site | Views: 2339 | Read more... Read more...   The Smart Cars User Rating: / 1 Written by Felix the Great!    Sunday, 16 August 2009 Comments (2) | Add as favourites (153) | Quote this article on your site | Views: 1878 | Read more... Read more...   More... Law of the Garbage Truck How to Fix Social Security Drinking with a Texas Girl Who New? Natural Remedies << Start < Prev 1 2 3 4 5 6 Next > End >> Results 1 - 9 of 53 [ Back ] Random Users admin victor addieja song martin_78752 sweetnikki happinessvirus KingAlexander hanah

© 2012 PCShare.Com

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/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_content&Itemid=108&id=6&lang=en&limit=9&limitstart=0&task=blogsection' AND `oldurl` = 'Mamblog/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 108 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1328466444' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1328472744' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = 'bb31a415432b17a7e897851f93a9f4d4'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = '61c03272263b2a2db3565b2245543db4'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '61c03272263b2a2db3565b2245543db4','1328473644','','0','1' )
11
SELECT *
 FROM jos_menu
 WHERE id = 108
12
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER 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:27' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:27' )
 AND ( a.sectionid=6 )
 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, 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
 INNER 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:27' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:27' )
 AND ( a.sectionid=6 )
 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 = 136
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 = 136
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
26
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '136'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=104&id=136&lang=en&task=favoured'
28
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=104&id=136&lang=en&task=quote'
29
SELECT hits FROM jos_content WHERE id = '136'
30
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=104&ac=0&id=136&lang=en&task=view'
31
SELECT title_alias,id FROM jos_content WHERE id=136
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=136
33
SELECT count(*) FROM jos_akocomment WHERE contentid='136' 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 = 135
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 = 135
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
44
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '135'
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=135&lang=en&task=favoured'
46
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=102&id=135&lang=en&task=quote'
47
SELECT hits FROM jos_content WHERE id = '135'
48
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=102&ac=0&id=135&lang=en&task=view'
49
SELECT title_alias,id FROM jos_content WHERE id=135
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=135
51
SELECT count(*) FROM jos_akocomment WHERE contentid='135' 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 = 134
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 = 134
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
62
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '134'
63
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=103&id=134&lang=en&task=favoured'
64
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=103&id=134&lang=en&task=quote'
65
SELECT hits FROM jos_content WHERE id = '134'
66
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=103&ac=0&id=134&lang=en&task=view'
67
SELECT title_alias,id FROM jos_content WHERE id=134
68
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=134
69
SELECT count(*) FROM jos_akocomment WHERE contentid='134' 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 = 133
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 = 133
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
80
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '133'
81
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=105&id=133&lang=en&task=favoured'
82
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=105&id=133&lang=en&task=quote'
83
SELECT hits FROM jos_content WHERE id = '133'
84
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=105&ac=0&id=133&lang=en&task=view'
85
SELECT title_alias,id FROM jos_content WHERE id=133
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=133
87
SELECT count(*) FROM jos_akocomment WHERE contentid='133' 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 = 131
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 = 131
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
98
SELECT COUNT(*) AS favourite FROM jos_akocomment_favoured WHERE id_content = '131'
99
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=105&id=131&lang=en&task=favoured'
100
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_akocomment&Itemid=105&id=131&lang=en&task=quote'
101
SELECT hits FROM jos_content WHERE id = '131'
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_content&Itemid=105&ac=0&id=131&lang=en&task=view'
103
SELECT title_alias,id FROM jos_content WHERE id=131
104
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=131
105
SELECT count(*) FROM jos_akocomment WHERE contentid='131' 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 = 108 )
 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:27' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-05 14:27' )
 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 = 130
 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 = 129
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
171
SELECT id 
 FROM jos_menu 
 WHERE type = 'content_blog_section'
 AND published = 1
 AND componentid = 0
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 = 128
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
173
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
174
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 62
175
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=62'
176
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
177
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=62'
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_uddeim&lang=en&recip=62&task=new'
180
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=62
181
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=62&lang=en&task=addConnection'
182
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
183
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=4&lang=en&task=showgroup'
184
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 = 98
185
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=98'
186
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
187
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=98'
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_uddeim&lang=en&recip=98&task=new'
190
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=98
191
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=98&lang=en&task=addConnection'
192
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
193
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
194
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=103'
195
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
196
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=103'
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_uddeim&lang=en&recip=103&task=new'
199
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=103
200
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=103&lang=en&task=addConnection'
201
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
202
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 = 91
203
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=91'
204
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
205
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=91'
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_uddeim&lang=en&recip=91&task=new'
208
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=91
209
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=91&lang=en&task=addConnection'
210
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
211
SELECT s.id_group, g.name FROM jos_gj_users s, jos_gj_groups g where s.id_group = g.id and s.id_user = 164
212
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=164'
213
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
214
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=164'
215
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
216
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=164&task=new'
217
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=164
218
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=164&lang=en&task=addConnection'
219
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
220
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
221
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=109'
222
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
223
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=109'
224
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
225
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=109&task=new'
226
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=109
227
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=109&lang=en&task=addConnection'
228
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
229
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
230
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=76'
231
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
232
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=76'
233
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
234
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_uddeim&lang=en&recip=76&task=new'
235
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=76
236
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=76&lang=en&task=addConnection'
237
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
238
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_groupjive&groupid=13&lang=en&task=showgroup'
239
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 = 119
240
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=119'
241
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
242
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=119'
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_uddeim&lang=en&recip=119&task=new'
245
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=119
246
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=119&lang=en&task=addConnection'
247
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
248
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
249
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=userProfile&user=75'
250
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'
251
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&lang=en&task=emailUser&uid=75'
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_uddeim&lang=en&recip=75&task=new'
254
select a.* FROM jos_comprofiler_members a  WHERE
a.referenceid=0 and a.memberid=75
255
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_comprofiler&act=connection&connectionid=75&lang=en&task=addConnection'
256
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_comprofiler%'