Main Menu

Home
Al-Qur'an Online
About Us
FAQ
Gemilang Agenda
Gemilang News
Gemilang Gallery
Gemilang Partner

Login Form






Lost Password?
No account yet? Register

Chatting

Admin Support

Online Admin1 Support1st Admin
Online Admin2 Support2nd Admin
© 2008 WIS.ro

Online Mode

We have 3 members online

Pengunjung

mod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_countermod_vvisit_counter
mod_vvisit_counterHari ini50
mod_vvisit_counterKemarin46
mod_vvisit_counterMinggu ini96
mod_vvisit_counterBulan ini389
mod_vvisit_counterSemua5248
Home
Wednesday, 10 March 2010
Gemilang Forum
Welcome, Guest
Please Login or Register.    Lost Password?
Perhatian!!
2009-12-03 06:25:24
10000 detik untuk user autologout 10000 detik untuk back User autologout
Gemilang Forum
(3 viewing) Sauhfaund , (2) Guests
Umum
  Forum Topics Replies Last Post
No New Posts
Ta'aruf
Perkenalkan terlebih dahulu diri Anda kepada anggota Forum Gemilang. Tapi ingat, bukan tempat PDKT ! ;)
1 7
Re:Adab Berta'aruf
by HDi | 10/11/2009 09:51 Show most recent message
No New Posts
Pertanyaan, Kritik dan Saran
Jangan segan untuk bertanya jika Anda kebingungan, karena pepatah mengatakan "Malu Bertanya sesat di Jalan". Tapi ingat jangan terlalu sering bertanya, itu hanya akan membuat Anda jadi terlihat blo'on. Kami juga menerima kritik, saran, masukan, cacian, hina'an untuk masa depan Gemilang yang lebih baik. (NB : Kalo ngasih cacian/makian jangan kelewatan)
7 19
Re:assalamualaikum.
by Ramya | 12/26/2009 03:45 Show most recent message
No New Posts
Latihan Posting
Buat newbie yang belum pernah ikutan forum atau yang udah ikutan forum tapi lupa cara posting, latihan di sini dulu aja yach..
0 0 No Posts
No New Posts
Berita Terbaru
Update berita terkini dari berbagai sumber. (InsyaAllah)
7 11
Re:[Numpang jualan] Compaq Presario v3700
by ginny | 03/07/2010 02:40 Show most recent message
No New Posts
Serious Discussion
Tempat diskusi tentang segala hal yang membutuhkan keseriusan. Hati2..
0 0 No Posts
IslamTempat postingan segala sesuatunya yang berhubungan dengan agama Allah S.W.T
  Forum Topics Replies Last Post
No New Posts
Aqidah
Kalo mau bahas tentang topik Aqidah, Tauhid, Rukun Iman, Hari Kiamat serta yang berhubungan dengan Deen Islam...Semuanya ada di sini
0 0 No Posts
No New Posts
Fiqih & Akhlak
Hukum syariat islam, adab serta akhlaq dengan berbagai konteksnya.
0 0 No Posts
No New Posts
Kajian
Semua pembahasan tentang Al-Qur'an, Hadist, dan segala macam jenis sumber hukum Islam.
0 0 No Posts
PendidikanTempat menimba ilmu pengetahuan yang bertaburan di alam semesta.
  Forum Topics Replies Last Post
No New Posts
Perguruan Tinggi
Buat tempat sharing ilmu pengetahuan dari akhi/ukhti yang sudah pada kuliah untuk adik-adiknya.
0 0 No Posts
No New Posts
SD, SMP, SMA/SMK, dan Madrasah
Untuk yang mau posting tentang pendidikan non-Perguruan Tinggi
0 0 No Posts
No New Posts
Beasiswa
Mau mencari dan/atau memberi tau tentang info beasiswa baik luar/dalam negeri. it's your place...
1 0
Info beasiswa S2 "KEMENEGPORA" angakatan 4
by rpurnama | 05/26/2009 14:07 Show most recent message
Lain-Lain
  Forum Topics Replies Last Post
No New Posts
Lowongan Kerja
Buat yang belum dapat kerja dan pengen nyari kerja atau pun yang pengen ngasih kerjaan, ini tempat nya.
2 3
Re:Selesaikan kewajiban antum di kuliahan...
by rpurnama | 06/08/2009 06:39 Show most recent message
No New Posts
Tong Sampah
Tempat pembuangan akhir untuk postingan-postingan yang dianggap ga penting. Warning : Kotor, Najis, Bau, dll.
0 0 No Posts
KonsultasiTempat konsultasi tentang ilmu-ilmu umum, ilmu-ilmu terapan, tips dan trik, kesehatan, website building, aneka software dan lain-lain disini tempatnya
  Forum Topics Replies Last Post
No New Posts
WEBSITE
ada keluhan website/blog? disini tempatnya untuk berdiskusi.
0 0 No Posts
Recent Posts

1

TopicAuthorCategoriesDateHits
emo Re:[Numpang jualan] Compaq Presario v3700ginnyBerita TerbaruSunday, 07 March 2010127
emo Re:Sabily 9.04 releasedginnyBerita TerbaruSunday, 07 March 2010199
emo Re:Sukses Musyawarah Terbatas GemilangGuestBerita TerbaruSaturday, 06 February 201065
emo Re:Jual KomputerGuestBerita TerbaruSaturday, 06 February 201082
emo Re:[KRC] Misi Kemanusiaan Untuk Gempa Sumatera BaratGuestBerita TerbaruSaturday, 06 February 2010105

2

TopicAuthorCategoriesDateHits
emo Re:assalamualaikum.GuestPertanyaan, Kritik dan SaranSaturday, 26 December 200981
emo Re:Boyongan Forum, YukkkkGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200987
emo Re:Template Baru......!!! Mohon saran lebih lanjutGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200968
emo Re:yang ga berkepentingan di kick-out ajGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200974
emo Re:mana ya kegiatan DPW lainnya?GuestPertanyaan, Kritik dan SaranSaturday, 26 December 200961
Gemilang Forum Forum Stats
Total Users: 212   Latest Member: STFrank
Total Messages: 67   Total Subjects: 23   Total Sections: 6   Total Categories: 22
Today Open: 0   Yesterday Open: 0   Today Total Answer: 0   Yesterday Total Answer: 0
» View Recent Posts » More About Stats » User List
Online 1 Member and 2 Guest
Sauhfaund  
New Posts- New Posts
No New Posts - No New Posts
Powered by FireBoardget the latest posts directly to your desktop
 

MiniFrontPage Module

Profil Institut Teknologi Sepuluh Nopember Surabaya (ITS)
06/11/2009

  Menjadi mahasiswa di Perguruan Tinggi terkemuka merupakan impian bagi sebagian besar siswa SMA. Keinginan untuk mengenyam pendidikan yang lebih tinggi dan kehausan untuk memperoleh informasi de [ ... ]


+ Lebih lengkap
Profil Universitas Airlangga (UNAIR)
06/11/2009

Bismillah, it's time to UNAIR. Siapa sih yang nggak kenal sama salah satu fakultas menakjubkan di belahan timur Indonesia ini. UNAIR adalah salah satu Universitas unggulan di Jawa Timur, menja [ ... ]


+ Lebih lengkap
Beastudi ETOS
06/11/2009

Beastudi Etos adalah beastudi untuk mahasiswa berpotensi namun memiliki keterbatasan ekonomi di sebelas perguruan tinggi negeri (PTN) di Indonesia. Bentuk beastudi yang diberikan adalah biaya masuk pe [ ... ]


+ Lebih lengkap
Profil Mahasiswa Berprestasi (1)
06/11/2009

ITS Online-Sama seperti mahasiswa pada umumnya, Muhammad Zia Mahriyar bukanlah mahasiswa super jenius layaknya Einstein. Namun ada hal-hal khusus yang dimilki oleh Zia, sapaan akrabnya, hingga ia  [ ... ]


+ Lebih lengkap
Cewek Cakep
06/11/2009

oleh: *Purbahayu  Cewek Cakep? Pasti subyektif banget ya. Katanya sih beda orang, beda kriteria. Ada yang menilai dari kilau rambut hitamnya, atau paduan kulit bersihnya yang bersinar terang. Ada [ ... ]


+ Lebih lengkap
Other Articles
255 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 menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 6 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1268159340' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268168440' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
7
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
8
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
9
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
10
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
11
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
12
SELECT *
 FROM jos_menu
 WHERE id = 6
13
SELECT * FROM jos_fb_config
14
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_fireboard' AND published = 1
15
SELECT template FROM jos_templates_menu where client_id ='0'
16
DELETE FROM jos_fb_whoisonline WHERE time < '1268167540'
17
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.107.191.92' AND userid='0'
18
INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) 
 VALUES ('0', '1268169340', 'Forum Main','','','','/', '38.107.191.92', '0')
19
SELECT moderator FROM jos_fb_users WHERE userid=0
20
SELECT id FROM jos_fb_categories WHERE pub_access=0 AND published=1
21
SELECT max(posts) from jos_fb_users
22
SELECT su.view, u.name, su.moderator,su.avatar FROM jos_fb_users as su
LEFT JOIN jos_users as u on u.id=su.userid WHERE su.userid=0
23
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 = 6 )
 ORDER BY ordering
24
SELECT * FROM jos_fb_categories WHERE parent= 0 and published=1 ORDER BY ordering
25
SELECT id,title,sdescription,description, created ,published,showdate
 FROM jos_fb_announcement  WHERE  published = 1 ORDER BY created DESC LIMIT 1
26
select * from jos_fb_categories where id=0 and published=1
27
SELECT w.userid, u.username AS username , k.showOnline FROM jos_fb_whoisonline AS w LEFT JOIN jos_users AS u ON u.id=w.userid LEFT JOIN jos_fb_users AS k ON k.userid=w.userid  WHERE w.link like '%/%'
28
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=9
29
SELECT moderator FROM jos_fb_users WHERE userid=0
30
SELECT c.*,m.subject, m.catid AS lastcat, m.name AS mname, m.userid, u.username, u.name AS uname
                    FROM jos_fb_categories AS c
                    LEFT JOIN jos_fb_messages AS m ON c.id_last_msg = m.id
                    LEFT JOIN jos_users AS u ON u.id = m.userid
                    WHERE c.parent='9' AND c.published='1'
                    ORDER BY ordering
31
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=14
32
SELECT moderator FROM jos_fb_users WHERE userid=0
33
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='14' AND published =1
34
SELECT userid FROM jos_fb_moderation WHERE catid='14'
35
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='63'
                                GROUP BY m.thread
36
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=14
37
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=15
38
SELECT moderator FROM jos_fb_users WHERE userid=0
39
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='15' AND published =1
40
SELECT userid FROM jos_fb_moderation WHERE catid='15'
41
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='78'
                                GROUP BY m.thread
42
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=15
43
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=16
44
SELECT moderator FROM jos_fb_users WHERE userid=0
45
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='16' AND published =1
46
SELECT userid FROM jos_fb_moderation WHERE catid='16'
47
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
48
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=16
49
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=17
50
SELECT moderator FROM jos_fb_users WHERE userid=0
51
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='17' AND published =1
52
SELECT userid FROM jos_fb_moderation WHERE catid='17'
53
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='85'
                                GROUP BY m.thread
54
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=17
55
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=29
56
SELECT moderator FROM jos_fb_users WHERE userid=0
57
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='29' AND published =1
58
SELECT userid FROM jos_fb_moderation WHERE catid='29'
59
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
60
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=29
61
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=4
62
SELECT moderator FROM jos_fb_users WHERE userid=0
63
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=24
64
SELECT moderator FROM jos_fb_users WHERE userid=0
65
SELECT c.*,m.subject, m.catid AS lastcat, m.name AS mname, m.userid, u.username, u.name AS uname
                    FROM jos_fb_categories AS c
                    LEFT JOIN jos_fb_messages AS m ON c.id_last_msg = m.id
                    LEFT JOIN jos_users AS u ON u.id = m.userid
                    WHERE c.parent='24' AND c.published='1'
                    ORDER BY ordering
66
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=25
67
SELECT moderator FROM jos_fb_users WHERE userid=0
68
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='25' AND published =1
69
SELECT userid FROM jos_fb_moderation WHERE catid='25'
70
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
71
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=25
72
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=26
73
SELECT moderator FROM jos_fb_users WHERE userid=0
74
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='26' AND published =1
75
SELECT userid FROM jos_fb_moderation WHERE catid='26'
76
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
77
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=26
78
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=28
79
SELECT moderator FROM jos_fb_users WHERE userid=0
80
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='28' AND published =1
81
SELECT userid FROM jos_fb_moderation WHERE catid='28'
82
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
83
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=28
84
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=19
85
SELECT moderator FROM jos_fb_users WHERE userid=0
86
SELECT c.*,m.subject, m.catid AS lastcat, m.name AS mname, m.userid, u.username, u.name AS uname
                    FROM jos_fb_categories AS c
                    LEFT JOIN jos_fb_messages AS m ON c.id_last_msg = m.id
                    LEFT JOIN jos_users AS u ON u.id = m.userid
                    WHERE c.parent='19' AND c.published='1'
                    ORDER BY ordering
87
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=20
88
SELECT moderator FROM jos_fb_users WHERE userid=0
89
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='20' AND published =1
90
SELECT userid FROM jos_fb_moderation WHERE catid='20'
91
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
92
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=20
93
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=23
94
SELECT moderator FROM jos_fb_users WHERE userid=0
95
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='23' AND published =1
96
SELECT userid FROM jos_fb_moderation WHERE catid='23'
97
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
98
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=23
99
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=21
100
SELECT moderator FROM jos_fb_users WHERE userid=0
101
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='21' AND published =1
102
SELECT userid FROM jos_fb_moderation WHERE catid='21'
103
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='13'
                                GROUP BY m.thread
104
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=21
105
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=18
106
SELECT moderator FROM jos_fb_users WHERE userid=0
107
SELECT c.*,m.subject, m.catid AS lastcat, m.name AS mname, m.userid, u.username, u.name AS uname
                    FROM jos_fb_categories AS c
                    LEFT JOIN jos_fb_messages AS m ON c.id_last_msg = m.id
                    LEFT JOIN jos_users AS u ON u.id = m.userid
                    WHERE c.parent='18' AND c.published='1'
                    ORDER BY ordering
108
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=27
109
SELECT moderator FROM jos_fb_users WHERE userid=0
110
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='27' AND published =1
111
SELECT userid FROM jos_fb_moderation WHERE catid='27'
112
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='30'
                                GROUP BY m.thread
113
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=27
114
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=22
115
SELECT moderator FROM jos_fb_users WHERE userid=0
116
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='22' AND published =1
117
SELECT userid FROM jos_fb_moderation WHERE catid='22'
118
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
119
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=22
120
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=30
121
SELECT moderator FROM jos_fb_users WHERE userid=0
122
SELECT c.*,m.subject, m.catid AS lastcat, m.name AS mname, m.userid, u.username, u.name AS uname
                    FROM jos_fb_categories AS c
                    LEFT JOIN jos_fb_messages AS m ON c.id_last_msg = m.id
                    LEFT JOIN jos_users AS u ON u.id = m.userid
                    WHERE c.parent='30' AND c.published='1'
                    ORDER BY ordering
123
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=31
124
SELECT moderator FROM jos_fb_users WHERE userid=0
125
SELECT id, name, numTopics, numPosts from jos_fb_categories WHERE parent='31' AND published =1
126
SELECT userid FROM jos_fb_moderation WHERE catid='31'
127
SELECT m.thread, count(*) AS totalmessages
                                FROM jos_fb_messages AS m
                                LEFT JOIN jos_fb_messages AS mm ON m.thread=mm.thread
                                WHERE m.id='0'
                                GROUP BY m.thread
128
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=31
129
SELECT u.id, IFNULL(u.username, 'Guest') AS username, IFNULL(u.name,'Guest') AS name, msg.subject, msg.id AS fbid, msg.catid, from_unixtime(msg.time) AS date, thread.hits AS hits, msg.locked, msg.topic_emoticon, msg.parent, cat.name AS catname FROM (SELECT msg1.* FROM (SELECT msg2.* FROM jos_fb_messages msg2 WHERE msg2.hold = 0 AND moved=0 AND msg2.catid IN (9,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31)  ORDER BY msg2.time DESC) msg1 GROUP BY msg1.thread) msg LEFT JOIN jos_users u ON u.id = msg.userid LEFT JOIN jos_fb_categories cat ON cat.id = msg.catid LEFT JOIN jos_fb_messages thread ON thread.id = msg.thread ORDER BY msg.time DESC LIMIT 10
130
SELECT COUNT(*) FROM jos_users
131
SELECT COUNT(*) FROM jos_fb_messages WHERE moved=0 AND hold=0
132
SELECT COUNT(*) FROM jos_fb_messages WHERE parent=0 AND moved=0 AND hold=0
133
SELECT COUNT(*) FROM jos_fb_categories WHERE parent=0
134
SELECT COUNT(*) FROM jos_fb_categories WHERE parent>0
135
SELECT id, username as username FROM jos_users WHERE block=0 AND activation='' ORDER BY id DESC LIMIT 0,1
136
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1268110801 AND time < 1268197199 AND parent>0
137
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1268024401 AND time < 1268110799 AND parent>0
138
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1268110801 AND time < 1268197199 AND parent=0
139
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1268024401 AND time < 1268110799 AND parent=0
140
SELECT p.userid, p.posts, u.username as username FROM jos_fb_users AS p
 LEFT JOIN jos_users AS u ON u.id = p.userid
 WHERE p.posts > 0 ORDER BY p.posts DESC LIMIT 5
141
SELECT u.uhits AS hits, u.userid AS user_id, j.username AS user  FROM jos_fb_users AS u
 LEFT JOIN jos_users AS j ON j.id = u.userid
 WHERE u.uhits > 0 ORDER BY u.uhits DESC LIMIT 5
142
SELECT uhits FROM jos_fb_users
 WHERE uhits > 0 ORDER BY uhits DESC LIMIT 1
143
SELECT posts FROM jos_fb_users WHERE posts > 0 ORDER BY posts DESC LIMIT 0,1
144
SELECT * FROM jos_fb_messages WHERE moved=0 AND hold=0 AND parent=0 ORDER BY hits DESC LIMIT 5
145
SELECT hits FROM jos_fb_messages WHERE moved=0 AND hold=0 AND parent=0 ORDER BY hits DESC LIMIT 1
146
SELECT COUNT(*) FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0
147
SELECT COUNT(*) FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0 AND m.parent= 0
148
SELECT m.*, m.time AS sendtime FROM jos_fb_messages AS m
 LEFT JOIN jos_fb_categories AS c ON c.id = m.catid
 LEFT JOIN jos_users AS u ON u.gid >= c.pub_access
 WHERE m.moved='0' AND u.id = 0 AND c.published = 1 AND m.hold = 0
 ORDER BY m.id DESC LIMIT 0,1
149
SELECT w.userip, w.time, w.what, u.username AS username, u.id, k.moderator, k.showOnline 
 FROM jos_fb_whoisonline AS w
 LEFT JOIN jos_users AS u ON u.id=w.userid 
 LEFT JOIN jos_fb_users AS k ON k.userid=w.userid 
 INNER JOIN jos_session AS s 
  ON s.guest=0 AND s.userid=w.userid 
 WHERE w.userid!=0 
 GROUP BY u.id 
  ORDER BY w.time DESC
150
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE user = 0
151
select id, title from jos_fb_groups as g, jos_fb_users as u where u.group_id = g.id and u.userid= 1141
152
select id, title from jos_fb_groups as g, jos_fb_users as u where u.group_id = g.id and u.userid= 1141
153
select id, title from jos_fb_groups
154
SELECT c.* FROM jos_fb_categories c WHERE c.id IN (9,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31) ORDER BY ordering, name
155
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
156
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'
157
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
158
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
159
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
160
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
161
SELECT guest, usertype
 FROM jos_session
162
CREATE TABLE IF NOT EXISTS jos_vvisit_counter (id int(11) NOT NULL AUTO_INCREMENT, tm int NOT NULL, ip varchar(16) NOT NULL default '0.0.0.0', PRIMARY KEY (`id`))
163
SELECT MAX(id) FROM jos_vvisit_counter
164
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.92' AND (tm+'900')>'1268169341'
165
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1268169341', '38.107.191.92')
166
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268110800'
167
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1268024400' and tm<'1268110800'
168
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1268024400'
169
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1267419600'
170
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
171
SELECT a.*, u.name, u.username, cc.image AS image
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 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 <= '2010-03-09 16:15' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-09 16:15' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND ( a.catid=1 OR a.catid=2 OR a.catid=3 OR a.catid=4 OR a.catid=5 OR a.catid=6 OR a.catid=7 )
 AND ( a.sectionid=1 OR a.sectionid=2 OR a.sectionid=3 OR a.sectionid=4 )
 AND ((TO_DAYS('2010-03-10') - TO_DAYS(a.created)) <= '12000000')
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created desc
 limit 0,10
172
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
173
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
174
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='31'
175
SELECT sectionid, catid FROM jos_content WHERE id='31'
176
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=2'
177
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='31'
178
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='31'
179
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
180
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
181
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
182
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
183
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='30'
184
SELECT sectionid, catid FROM jos_content WHERE id='30'
185
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=2'
186
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='30'
187
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='30'
188
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
189
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
190
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=29'
191
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=29'
192
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='29'
193
SELECT sectionid, catid FROM jos_content WHERE id='29'
194
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=2'
195
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='29'
196
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='29'
197
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
198
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
199
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=28'
200
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=28'
201
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='28'
202
SELECT sectionid, catid FROM jos_content WHERE id='28'
203
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=3'
204
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='28'
205
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='28'
206
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
207
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
208
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
209
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
210
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='26'
211
SELECT sectionid, catid FROM jos_content WHERE id='26'
212
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=3'
213
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='26'
214
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='26'
215
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
216
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
217
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
218
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
219
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='25'
220
SELECT sectionid, catid FROM jos_content WHERE id='25'
221
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=3'
222
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='25'
223
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='25'
224
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
225
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
226
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=24'
227
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=24'
228
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='24'
229
SELECT sectionid, catid FROM jos_content WHERE id='24'
230
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=4'
231
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='24'
232
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='24'
233
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
234
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
235
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=23'
236
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=23'
237
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='23'
238
SELECT sectionid, catid FROM jos_content WHERE id='23'
239
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=4'
240
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='23'
241
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='23'
242
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
243
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
244
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=21'
245
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=21'
246
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='21'
247
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
248
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
249
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_section' AND m.published='1' AND i.id='20'
250
SELECT sectionid, catid FROM jos_content WHERE id='20'
251
SELECT id FROM jos_menu WHERE type='content_category' AND published='1' AND link='index.php?option=com_content&task=category§ionid=2&id=4'
252
SELECT m.id FROM jos_content AS i LEFT JOIN jos_sections AS s ON i.sectionid=s.id LEFT JOIN jos_menu AS m ON m.componentid=s.id WHERE m.type='content_blog_section' AND m.published='1' AND i.id='20'
253
SELECT m.id FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_menu AS m ON m.componentid=c.id WHERE m.type='content_blog_category' AND m.published='1' AND i.id='20'
254
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
255
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'