
</td></tr></table><b>Database error:</b> 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-08-19 00:00:00')) AND a.is_special !=3 AND a.is_special !=4 order by a.date_activated DESC<br>
<b>MySQL Error</b>: 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)<br>
Session halted.