Database error: Invalid SQL: SELECT
a.id_properti as a_id_properti,
a.id_branch as a_id_branch,
a.is_special as a_is_special,
a.id_ref_type_properti as a_id_ref_type_properti,
a.id_ref_transaksi as a_id_ref_transaksi,
a.id_ref_currency as a_id_ref_currency,
a.nama as a_nama,
a.perumahan as a_perumahan,
a.alamat as a_alamat,
a.luas_tanah as a_luas_tanah,
a.luas_bangunan as a_luas_bangunan,
i.nama as kurs,
a.harga as a_harga,
a.kamar_tidur as a_kamar_tidur,
a.kamar_mandi as a_kamar_mandi,
a.foto_1 as a_foto_1_list,
a.status as a_status,
a.viewed as a_viewed,
b.id_member_acc as b_id_member_acc,
b.nama as b_nama_member,
c.nama as c_nama_type_properti,
d.nama as d_nama_transaksi,
e.nama as e_nama_propinsi,
f.nama as f_nama_kota,
g.nama as g_nama_kecamatan,
h.nama as h_nama_kelurahan,
a.date_activated as a_date_activated,
TO_DAYS( NOW( ) ) - TO_DAYS( a.date_activated ) as baru,
CASE
WHEN p.id_perusahaan > 0 THEN 1
ELSE p.id_perusahaan=0
END as p_id_perusahaan
FROM
properti a
LEFT JOIN
ref_type_properti c ON c.id_ref_type_properti = a.id_ref_type_properti
LEFT JOIN
ref_transaksi d ON d.id_ref_transaksi = a.id_ref_transaksi
LEFT JOIN
member_acc b ON b.id_member_acc = a.id_member_acc AND b.id_branch = a.id_branch
LEFT JOIN
ref_propinsi e ON e.id_ref_propinsi = a.id_ref_propinsi
LEFT JOIN
ref_kota f ON f.id_ref_kota = a.id_ref_kota
LEFT JOIN
ref_kecamatan g ON g.id_ref_kecamatan = a.id_ref_kecamatan
LEFT JOIN
ref_kelurahan h ON h.id_ref_kelurahan = a.id_ref_kelurahan
LEFT JOIN
ref_currency i ON i.id_ref_currency = a.id_ref_currency
LEFT JOIN
perusahaan p ON p.id_member_acc=a.id_member_acc and p.id_branch=a.id_branch
WHERE 1
AND a.id_ref_type_properti = 5 AND a.harga > 500000000 AND a.id_ref_currency= AND a.harga <= 1000000000 AND a.id_ref_currency= AND ((a.status = 1 AND a.date_expired >= '2018-04-21 00:00:00')) AND a.is_special !=3 AND a.is_special !=4 order by a.date_activated DESC
MySQL Error: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND a.harga <= 1000000000 AND a.id_ref_currency= AND ((a.status = 1 AND a.date_e' at line 55)
Session halted.