(mysql): select banner_link, banner_image, banner_desc from jcamp_banners where banner_position = 'righttop' order by banner_order limit 1

(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 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

Belum ada yang dibandingkan.
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

(mysql): select link, menu_title from jcamp_menu where link = 'index.php?action=register.perpanjangan' and menu_title != 'Home'

Home » Perpanjangan Member

Member Login