Advertisement
Guest User

Untitled

a guest
Aug 27th, 2014
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.20 KB | None | 0 0
  1. SELECT id, place_name,
  2. ROUND( SQRT( POW((69.1 * (#Val(arguments.latitude)# - latitude)), 2) + POW((53 * (#Val(arguments.longitude)# - longitude)), 2)), 1) AS distance
  3. FROM places
  4. ORDER BY distance ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement