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 Fork')) OR locationID IN (SELECT locationID ' at line 8

SELECT DISTINCT location.* FROM (`location`) WHERE location.locationID IN (SELECT locationID FROM location_zip WHERE zip IN ('37064')) OR location.locationID IN (SELECT locationID FROM location_city WHERE city IN ('Leiper's Fork')) OR locationID IN (SELECT locationID FROM location_highlight WHERE itemType = 'venue' AND itemID = 30885)