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 'asc,p.name LIMIT 0,10' at line 1

select p.id from property p left join property_site ps on p.id=ps.property_id and ps.site_id=6 where ( ps.status is null or ps.status='visible') and ( p.status='live' and 1=1 ) AND (p.`features` like '%226%' or p.`name` like '%226%' or `reference` like '%226%' or `town` like '%226%' or `location_information` like '%226%') group by p.id order by LOCATE('226',name) desc asc,p.name LIMIT 0,10