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
(3 viewing) Sauhfaund , (2) Guests
  Forum Topics Replies Last Post
No New Posts
Perkenalkan terlebih dahulu diri Anda kepada anggota Forum Gemilang. Tapi ingat, bukan tempat PDKT ! ;)
1 7
by HDi | 10/11/2009 09:51 Show most recent message
No New Posts
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
by Ramya | 12/26/2009 03:45 Show most recent message
No New Posts
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
Update berita terkini dari berbagai sumber. (InsyaAllah)
7 11
by ginny | 03/07/2010 02:40 Show most recent message
No New Posts
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
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
Hukum syariat islam, adab serta akhlaq dengan berbagai konteksnya.
0 0 No Posts
No New Posts
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
Buat tempat sharing ilmu pengetahuan dari akhi/ukhti yang sudah pada kuliah untuk adik-adiknya.
0 0 No Posts
No New Posts
Untuk yang mau posting tentang pendidikan non-Perguruan Tinggi
0 0 No Posts
No New Posts
Mau mencari dan/atau memberi tau tentang info beasiswa baik luar/dalam negeri. it's your place...
1 0
by rpurnama | 05/26/2009 14:07 Show most recent message
  Forum Topics Replies Last Post
No New Posts
Buat yang belum dapat kerja dan pengen nyari kerja atau pun yang pengen ngasih kerjaan, ini tempat nya.
2 3
by rpurnama | 06/08/2009 06:39 Show most recent message
No New Posts
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
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
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
New Posts- New Posts
No New Posts - No New Posts

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 [ ... ]


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 [ ... ]


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 [ ... ]


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  [ ... ]


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 [ ... ]


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'