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 ini30
mod_vvisit_counterKemarin53
mod_vvisit_counterMinggu ini30
mod_vvisit_counterBulan ini305
mod_vvisit_counterSemua4127
Home
Tuesday, 09 February 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
(2 viewing) (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 9
Re:Sabily 9.04 released
by eagle1r | 02/05/2010 21:45 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:Sabily 9.04 releasedGuestBerita TerbaruSaturday, 06 February 2010174
emo Re:Sukses Musyawarah Terbatas GemilangGuestBerita TerbaruSaturday, 06 February 201059
emo Re:Jual KomputerGuestBerita TerbaruSaturday, 06 February 201077
emo Re:[Numpang jualan] Compaq Presario v3700GuestBerita TerbaruSaturday, 06 February 2010111
emo Re:[KRC] Misi Kemanusiaan Untuk Gempa Sumatera BaratGuestBerita TerbaruSaturday, 06 February 201083

2

TopicAuthorCategoriesDateHits
emo Re:assalamualaikum.GuestPertanyaan, Kritik dan SaranSaturday, 26 December 200971
emo Re:Boyongan Forum, YukkkkGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200983
emo Re:Template Baru......!!! Mohon saran lebih lanjutGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200967
emo Re:yang ga berkepentingan di kick-out ajGuestPertanyaan, Kritik dan SaranSaturday, 26 December 200973
emo Re:mana ya kegiatan DPW lainnya?GuestPertanyaan, Kritik dan SaranSaturday, 26 December 200956
Gemilang Forum Forum Stats
Total Users: 34   Latest Member: orgampannob
Total Messages: 65   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 0 Members and 2 Guests
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
253 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 < '1265660261' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1265669361' )
 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 < '1265668461'
17
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.107.191.91' AND userid='0'
18
INSERT INTO jos_fb_whoisonline (`userid` , `time`, `what`, `task`, `do`, `func`,`link`, `userip`, `user`) 
 VALUES ('0', '1265670261', 'Forum Main','','','','/', '38.107.191.91', '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='83'
                                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 > 1265605201 AND time < 1265691599 AND parent>0
137
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1265518801 AND time < 1265605199 AND parent>0
138
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1265605201 AND time < 1265691599 AND parent=0
139
SELECT COUNT(*) FROM jos_fb_messages WHERE time > 1265518801 AND time < 1265605199 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
152
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
153
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
154
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'
155
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
156
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
157
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
158
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=1'
159
SELECT guest, usertype
 FROM jos_session
160
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`))
161
SELECT MAX(id) FROM jos_vvisit_counter
162
SELECT COUNT(*) FROM jos_vvisit_counter WHERE ip='38.107.191.91' AND (tm+'900')>'1265670262'
163
INSERT INTO jos_vvisit_counter (id, tm, ip) VALUES ('', '1265670262', '38.107.191.91')
164
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1265605200'
165
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>'1265518800' and tm<'1265605200'
166
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1265605200'
167
SELECT COUNT(*) FROM jos_vvisit_counter WHERE tm>='1265000400'
168
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
169
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-02-08 18:04' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-02-08 18:04' )
 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-02-09') - TO_DAYS(a.created)) <= '12000000')
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created desc
 limit 0,10
170
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
171
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=31'
172
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'
173
SELECT sectionid, catid FROM jos_content WHERE id='31'
174
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'
175
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'
176
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'
177
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
178
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
179
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
180
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=30'
181
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'
182
SELECT sectionid, catid FROM jos_content WHERE id='30'
183
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'
184
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'
185
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'
186
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
187
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
188
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=29'
189
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=29'
190
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'
191
SELECT sectionid, catid FROM jos_content WHERE id='29'
192
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'
193
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'
194
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'
195
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
196
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
197
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=28'
198
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=28'
199
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'
200
SELECT sectionid, catid FROM jos_content WHERE id='28'
201
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'
202
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'
203
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'
204
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
205
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
206
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
207
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=26'
208
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'
209
SELECT sectionid, catid FROM jos_content WHERE id='26'
210
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'
211
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'
212
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'
213
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
214
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
215
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
216
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=25'
217
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'
218
SELECT sectionid, catid FROM jos_content WHERE id='25'
219
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'
220
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'
221
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'
222
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
223
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
224
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=24'
225
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=24'
226
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'
227
SELECT sectionid, catid FROM jos_content WHERE id='24'
228
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'
229
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'
230
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'
231
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
232
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
233
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=23'
234
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=23'
235
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'
236
SELECT sectionid, catid FROM jos_content WHERE id='23'
237
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'
238
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'
239
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'
240
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
241
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'
242
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=21'
243
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=21'
244
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'
245
SELECT id FROM jos_menu WHERE type='content_item_link' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
246
SELECT id FROM jos_menu WHERE type='content_typed' AND published='1' AND link='index.php?option=com_content&task=view&id=20'
247
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'
248
SELECT sectionid, catid FROM jos_content WHERE id='20'
249
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'
250
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'
251
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'
252
SELECT id FROM jos_menu WHERE type='content_blog_section' AND published='1' AND componentid='0'
253
SELECT id FROM jos_menu WHERE type='content_blog_category' AND published='1' AND componentid='0'