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 (
forsale.status =2 OR forsale.status =4 OR forsale.status =7
)
ORDER BY pri' at line 6<hr>SELECT forsale.prop_id, forsale.title, forsale.dflt_image,  forsale.price, forsale.seller_id, forsale.location, forsale.tenure, forsale.rooms_bed, forsale.rooms_rec, forsale.prop_type, forsale.locationtype, forsale.status,  opt_proptype.proptype_desc, opt_locationtype.loctype_desc, forsale.eu_currency
FROM forsale
LEFT JOIN opt_proptype ON forsale.prop_type = opt_proptype.proptype_id
LEFT JOIN opt_locationtype ON forsale.locationtype = opt_locationtype.loctype_id
WHERE eu_country  = 
AND (
forsale.status =2 OR forsale.status =4 OR forsale.status =7
)
ORDER BY price DESC