"SELECT ".$SQL['Shows'].".eventid, ".$SQL['Shows'].".artistid, ".$SQL['Shows'].".venue, ".$SQL['Shows'].".date, ".$SQL['Ratings'].".rating, ROUND( SQRT( POW((69.1 * ($UserLat - ".$SQL['Zip'].".lat)), 2) + POW((53 * ($UserLon - ".$SQL['Zip'].".lon)), 2)), 1) AS distance FROM ".$SQL['Shows']." JOIN ".$SQL['Similar']." ON ".$SQL['Shows'].".artistid=".$SQL['Similar'].".linkartistid JOIN ".$SQL['Ratings']." ON ".$SQL['Ratings'].".artistid=".$SQL['Similar'].".artistid JOIN ".$SQL['Zip']." ON ".$SQL['Shows'].".zipcode=".$SQL['Zip'].".zip WHERE ".$SQL['Ratings'].".userid='$UserID' HAVING distance < 100 ORDER BY distance