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 = 9 AND a.harga > 5000000000 AND a.id_ref_currency= AND a.harga <= 999999000000 AND a.id_ref_currency= AND ((a.status = 1 AND a.date_expired >= '2017-11-19 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 <= 999999000000 AND a.id_ref_currency= AND ((a.status = 1 AND' at line 55)
Session halted.