(mysql): SELECT module_name, block_theme, block_title, block_name FROM `jcamp_block_theme` b LEFT JOIN jcamp_module m ON ( m.module_id = b.block_module_id ) WHERE theme_name = 'blue' AND `block_position` = 'righttop' AND block_publish = '1' AND ( ( `block_access` = 'all' OR `block_access` = 'publishunlogged' OR `block_access` = 'allpublish') ) ORDER BY block_order
Search
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = 0 ORDER BY title ASC
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = '2' ORDER BY title
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = '4' ORDER BY title
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = '3' ORDER BY title
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = '1' ORDER BY title
(mysql): SELECT * FROM iklan_cat WHERE par_cat_id = '5' ORDER BY title
(mysql): SELECT state_id as id, state_name as name FROM ref_state ORDER BY state_id
(mysql): SELECT city_id as id, city_name as name, state_id FROM ref_city ORDER BY state_id, city_name
Compare
Max. 3 properti.
(mysql): SELECT module_name, block_theme, block_title, block_name FROM `jcamp_block_theme` b LEFT JOIN jcamp_module m ON ( m.module_id = b.block_module_id ) WHERE theme_name = 'blue' AND `block_position` = 'right' AND block_publish = '1' AND ( ( `block_access` = 'all' OR `block_access` = 'publishunlogged' OR `block_access` = 'allpublish') ) ORDER BY block_order
Sponsor
(mysql): select * from jcamp_banners where banner_position = 'right' AND publish ='1' order by banner_order limit 3
Statistik
(mysql): delete from ref_counter where time <= 1337528992
(mysql): select count as jml from ref_count_counter LIMIT 1
(mysql): select count(id_member) from iklan_member where active = 1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE DATE_FORMAT(iklan_date, '%Y-%m-%d') = CURDATE() LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE DATE_FORMAT(iklan_date, '%Y-%m-%d') = CURDATE() LIMIT 1
| Total Iklan: | 4066 |
| Iklan Hari Ini: | 0 |
| Total Member: | 4069 |
| Guest Online: | 15 |
| Visited: | 729778 |
Transaksi
(mysql): SELECT COUNT(iSold) FROM iklan WHERE iSold=1 AND MONTH(iSoldDate)= '5' AND YEAR(iSoldDate) = '2012' LIMIT 1
(mysql): SELECT COUNT(iSold) FROM iklan_premium WHERE iSold=1 AND MONTH(iSoldDate) = '5' AND YEAR(iSoldDate) = '2012' LIMIT 1
(mysql): SELECT SUM(iPrice) FROM iklan WHERE iSold=1 AND MONTH(iSoldDate) = '5' AND YEAR(iSoldDate) = '2012' LIMIT 1
(mysql): SELECT SUM(iPrice) FROM iklan_premium WHERE iSold=1 AND MONTH(iSoldDate) = '5' AND YEAR(iSoldDate) = '2012' LIMIT 1
Estimasi Transaksi 2012
Bulan : Mei |
Terjual/Tersewa |
| 0 unit |
Estimasi Nilai |
| Rp. 0,00 |
Total Transaksi |
(mysql): SELECT module_name, block_theme, block_title, block_name FROM `jcamp_block_theme` b LEFT JOIN jcamp_module m ON ( m.module_id = b.block_module_id ) WHERE theme_name = 'blue' AND `block_position` = 'left' AND block_publish = '1' AND ( ( `block_access` = 'all' OR `block_access` = 'publishunlogged' OR `block_access` = 'allpublish') ) ORDER BY block_order
Kategori Properti
-
(mysql): SELECT cat_id, par_cat_id, title as kategori, seftitle FROM iklan_cat WHERE par_cat_id = 0 ORDER BY cat_id,par_cat_id
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE id_iklan_cat IN('1') AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE id_iklan_cat IN('1') AND iklan_publish=1 LIMIT 1
Rumah (2035)
(mysql): SELECT cat_id as cat, title as sub_kategori, seftitle FROM iklan_cat WHERE par_cat_id = 1 ORDER BY cat_id,par_cat_id
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE id_iklan_cat IN('2') AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE id_iklan_cat IN('2') AND iklan_publish=1 LIMIT 1
Apartemen (30)
(mysql): SELECT cat_id as cat, title as sub_kategori, seftitle FROM iklan_cat WHERE par_cat_id = 2 ORDER BY cat_id,par_cat_id
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE id_iklan_cat IN('3') AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE id_iklan_cat IN('3') AND iklan_publish=1 LIMIT 1
Ruko (1938)
(mysql): SELECT cat_id as cat, title as sub_kategori, seftitle FROM iklan_cat WHERE par_cat_id = 3 ORDER BY cat_id,par_cat_id
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE id_iklan_cat IN('4') AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE id_iklan_cat IN('4') AND iklan_publish=1 LIMIT 1
Ruang Usaha (12)
(mysql): SELECT cat_id as cat, title as sub_kategori, seftitle FROM iklan_cat WHERE par_cat_id = 4 ORDER BY cat_id,par_cat_id
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE id_iklan_cat IN('5') AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE id_iklan_cat IN('5') AND iklan_publish=1 LIMIT 1
Tanah (50)
(mysql): SELECT cat_id as cat, title as sub_kategori, seftitle FROM iklan_cat WHERE par_cat_id = 5 ORDER BY cat_id,par_cat_id
Status Properti
(mysql): SELECT COUNT(id_search) FROM iklan_search WHERE active = 1 LIMIT 1
-
Dijual (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iType = 0 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iType = 0 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
241)Disewakan (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iType = 1 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iType = 1 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
3765)Dicari (11)
Area Properti
-
(mysql): SELECT * FROM ref_state ORDER BY state_name
Bali (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 1 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 1 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
12)
(mysql): SELECT * FROM ref_city WHERE state_id = 1 ORDER BY city_name LIMIT 5
Badung, Bangli, Buleleng, Denpasar, Gianyar, ...Banten (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 2 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 2 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
22)
(mysql): SELECT * FROM ref_city WHERE state_id = 2 ORDER BY city_name LIMIT 5
Cilegon, Lebak, Pandegelang, Serang, Tangerang, ...Bengkulu (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 3 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 3 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 3 ORDER BY city_name LIMIT 5
Bengkulu, Bengkulu Selatan, Bengkulu Utara, Rejang Lebong, ...DI Aceh (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 4 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 4 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
2)
(mysql): SELECT * FROM ref_city WHERE state_id = 4 ORDER BY city_name LIMIT 5
Aceh Barat, Aceh Besar, Aceh Selatan, Aceh Singkil, Aceh Tengah, ...DI Yogyakarta (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 5 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 5 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
3)
(mysql): SELECT * FROM ref_city WHERE state_id = 5 ORDER BY city_name LIMIT 5
Bantul, Gunung Kidul, Kulon Progo, Sleman, Yogyakarta, ...DKI Jakarta (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 6 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 6 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
127)
(mysql): SELECT * FROM ref_city WHERE state_id = 6 ORDER BY city_name LIMIT 5
Jakarta Barat, Jakarta Pusat, Jakarta Selatan, Jakarta Timur, Jakarta Utara, ...Irian Jaya (Papua) (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 7 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 7 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
1)
(mysql): SELECT * FROM ref_city WHERE state_id = 7 ORDER BY city_name LIMIT 5
Biak Numpor, Fak-Fak, Jayapura, Jayawijaya, Manokwari, ...Jambi (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 8 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 8 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 8 ORDER BY city_name LIMIT 5
Batang Hari, Bungo Tebo, Jambi, Kerinci, Sarolangun Bangko, ...Jawa Barat (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 9 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 9 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
98)
(mysql): SELECT * FROM ref_city WHERE state_id = 9 ORDER BY city_name LIMIT 5
Bandung, Bekasi, Bogor, Ciamis, Cianjur, ...Jawa Tengah (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 10 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 10 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
12)
(mysql): SELECT * FROM ref_city WHERE state_id = 10 ORDER BY city_name LIMIT 5
Banjarnegara, Banyumas, Batang, Blora, Boyolali, ...Jawa Timur (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 11 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 11 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
27)
(mysql): SELECT * FROM ref_city WHERE state_id = 11 ORDER BY city_name LIMIT 5
Bangkalan, Banyuwangi, Blitar, Bojonegoro, Bondowoso, ...Kalimantan Barat (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 12 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 12 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
1)
(mysql): SELECT * FROM ref_city WHERE state_id = 12 ORDER BY city_name LIMIT 5
Bengkayang, Kapuas Hulu, Katapang, Pontianak, Sambas, ...Kalimantan Selatan (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 13 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 13 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 13 ORDER BY city_name LIMIT 5
Banjar, Banjarbaru, Banjarmasin, Barito Kuala, Kota Baru, ...Kalimantan Tengah (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 14 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 14 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 14 ORDER BY city_name LIMIT 5
Barito Selatan, Barito Utara, Kapuas, Kotawaringin Barat, Kotawaringin Timur, ...Kalimantan Timur (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 15 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 15 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
1)
(mysql): SELECT * FROM ref_city WHERE state_id = 15 ORDER BY city_name LIMIT 5
Balikpapan, Berau, Bulungan, Kutai, Pasir, ...Lampung (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 16 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 16 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 16 ORDER BY city_name LIMIT 5
Bandar Lampung, Lampung Barat, Lampung Selatan, Lampung Tengah, Lampung Timur, ...Maluku (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 17 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 17 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 17 ORDER BY city_name LIMIT 5
Ambon, Halmahera Tengah, Maluku Tengah, Maluku Tenggara, Maluku Utara, ...Nusa Tenggara Barat (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 18 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 18 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 18 ORDER BY city_name LIMIT 5
Bima, Dompu, Lombok Barat, Lombok Tengah, Lombok Timur, ...Nusa Tenggara Timur (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 19 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 19 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 19 ORDER BY city_name LIMIT 5
Alor, Belu, Ende, Flores Timur, Kupang, ...Riau (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 20 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 20 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
2)
(mysql): SELECT * FROM ref_city WHERE state_id = 20 ORDER BY city_name LIMIT 5
Batam, Bengkalis, Dumai, Indragiri Hilir, Indragiri Hulu, ...Sulawesi Selatan (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 21 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 21 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 21 ORDER BY city_name LIMIT 5
Bantaeng, Barru, Bone, Bulukumba, Enrekang, ...Sulawesi Tengah (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 22 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 22 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 22 ORDER BY city_name LIMIT 5
Banggai, Buol Toli-Toli, Donggala, Palu, Poso, ...Sulawesi Tenggara (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 23 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 23 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 23 ORDER BY city_name LIMIT 5
Buton, Kendari, Kolaka, Muna, ...Sulawesi Utara (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 24 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 24 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 24 ORDER BY city_name LIMIT 5
Bitung, Bolaang Mongondow, Gorontalo, Manado, Minahasa, ...Sumatra Barat (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 25 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 25 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
1)
(mysql): SELECT * FROM ref_city WHERE state_id = 25 ORDER BY city_name LIMIT 5
Agam, Bukit Tinggi, Limapuluh Kota, Padang, Padang Panjang, ...Sumatra Selatan (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 26 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 26 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
0)
(mysql): SELECT * FROM ref_city WHERE state_id = 26 ORDER BY city_name LIMIT 5
Bangka, Belitung, Lahat, Muara Enim, Musi Banyusin, ...Sumatra Utara (
(mysql): SELECT COUNT(id_iklan) FROM iklan WHERE iState = 27 AND iklan_publish=1 LIMIT 1
(mysql): SELECT COUNT(id_iklan) FROM iklan_premium WHERE iState = 27 AND iklan_publish=1 AND iExpDate >= CURDATE() LIMIT 1
8)
(mysql): SELECT * FROM ref_city WHERE state_id = 27 ORDER BY city_name LIMIT 5
Asahan, Binjai, Dairi, Deli Serdang, Karo, ...
(mysql): SELECT module_name, block_theme, block_title, block_name FROM `jcamp_block_theme` b LEFT JOIN jcamp_module m ON ( m.module_id = b.block_module_id ) WHERE theme_name = 'blue' AND `block_position` = 'rightbottom' AND block_publish = '1' AND ( ( `block_access` = 'all' OR `block_access` = 'publishunlogged' OR `block_access` = 'allpublish') ) ORDER BY block_order
Tag Populer
(mysql): SELECT label FROM iklan_premium WHERE iExpDate >= CURDATE() AND iklan_publish = 1
(mysql): SELECT label FROM iklan WHERE iklan_publish = 1
- Antapani
- BSD
- Bandung
- Bandung Tengah
- Bandung Utara
- Bekasi
- Bintaro
- Bogor
- Cibubur
- Cikarang
- Denpasar
- Depok
- Dijual
- Disewa
- Gading Serpong
- Jagakarsa
- Jakarta Barat
- Jakarta Pusat
- Jakarta Selatan
- Jakarta Timur
- Jakarta Utara
- Kelapa Gading
- Malang
- Pesanggrahan
- Petukangan
- Ruko
- Rumah
- Semarang
- Sleman
- Sukmajaya
- Surabaya
- Tangerang
- Tebet
- Yogyakarta
(mysql): select link, menu_title from jcamp_menu where link = 'index.php?action=register.perpanjangan' and menu_title != 'Home'
Home » Perpanjangan Member


