A Database Error Occurred

Error Number: 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.prop_type_id='' ORDER BY tot_view desc,detail_view desc LIMIT 5' at line 1

SELECT a.prop_id,a.prop_name,a.prop_price,a.prop_area,a.price_on_request,a.unitprice_on_request,(select unit_name from dt_unit_master where unit_id=a.unit_id) as unit_type,a.price_per_unit,a.prop_pic FROM dt_property_master a,dt_prop_transaction_master b WHERE a.prop_id=b.prop_id AND a.is_sold='N' AND a.is_parent='Y' AND a.is_active='Y' AND (b.trans_mode='L' OR b.trans_mode='LS') AND a.city_id= AND a.prop_type_id='' ORDER BY tot_view desc,detail_view desc LIMIT 5