An Error Was Encountered

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 'Neill' and award_level = 1 order by award_year, award_ptype limit 0, 10' at line 1

select award_title, award_year, award_ttype, award_ptype, award_atype, award_level from awards where award_author = 'Scott O\\'Neill' and award_level = 1 order by award_year, award_ptype limit 0, 10