Error in executing SELECT id,name,address1,address2,address3,town,county,postcode,country,phone,emailaddress,showemail,url,accommtypes,description FROM ukdirectory WHERE accommtypes LIKE '%%' 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 near 's bay' AND status = '' ORDER BY priority ASC, name ASC' at line 1