Error in executing SELECT id,name,address1,address2,address3,town,county,postcode,country,phone,emailaddress,showemail,url,accommtypes,description FROM ukdirectory WHERE accommtypes LIKE '%SC%' AND country LIKE 'england' AND county LIKE 'north yorkshire' AND town LIKE 'robin hood's bay' AND status = '' ORDER BY priority ASC, name ASC query

error: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 's bay' AND status = '' ORDER BY priority ASC, name ASC' at line 1