Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, place_name,
- ROUND( SQRT( POW((69.1 * (#Val(arguments.latitude)# - latitude)), 2) + POW((53 * (#Val(arguments.longitude)# - longitude)), 2)), 1) AS distance
- FROM places
- ORDER BY distance ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement