Process Halted!

Error:db::query() failed.ERROR MESSAGE IS: Failed to run Query:select distinct property.property_id,property.region,region.name,region.region_id,property.thumb,property.stars,property.short_description,property.title,property.city,property.active1,property.type,p_type.name as type_name from property inner join p_type on property.type=p_type.type_id LEFT join region on region.region_id=property.region LEFT JOIN region_subregion ON region_subregion.region_id = region.region_id where 1=1 and property.active1='1' and p_type.type_id not in (3,4) and property.city='O'Connor' order by property.property_id 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 'Connor' order by property.property_id' at line 5