sql say: 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 ( ((upper(prop.country) like upper('%spain%') )) ) order by (1' at line 1

---

query: select prop.prop_id, prop.bedrooms, prop.propertytype, prop.area, prop.sleeps, prop.lowrent, prop.currency, prop.highrent, prop.rentperiod from prop where ( ((upper(prop.area) like upper('%cala dor%') )) or ((upper(prop.area) like upper('%d'or%') )) ) and ( ((upper(prop.country) like upper('%spain%') )) ) order by (1223884939-prop._last_login > (30*86400)), (1223884939-prop._last_login < (30*86400)), , rand(1223884939) limit 0, 1000