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 's Goose%' AND user_Listing.user = 'OHbirderSC' AND user_Listing.Privacy = 3 AND ' at line 4

SELECT count(ID) as thecount FROM user_Listing JOIN user_Locations ON user_Locations.RBA_Locations_ID = user_Listing.RBALocationsID WHERE user_Listing.SpeciesList like '%Ross's Goose%' AND user_Listing.user = 'OHbirderSC' AND user_Listing.Privacy = 3 AND user_Listing.RBALocationsID != 0 AND user_Listing.deleted = 0