Stuff
public text v1 · immutable"SELECT Events.eventid, Events.artistid, Events.venue, Events.date, Ratings.rating, ROUND( SQRT( POW((69.1 * ($UserLat - ZipData.lat)), 2) + POW((53 * ($UserLon - ZipData.lon)), 2)), 1) AS distance FROM Events JOIN SimilarArtists ON Events.artistid=SimilarArtists.linkartistid JOIN Ratings ON Ratings.artistid=SimilarArtists.artistid JOIN ZipData ON Events.zipcode=ZipData.zip WHERE Ratings.userid='$UserID' HAVING distance < 100 ORDER BY distance