Advertisement
Guest User

Untitled

a guest
May 25th, 2017
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.27 KB | None | 0 0
  1. SELECT station, (3959 * acos(cos(radians(-0.055728000000)) * cos(radians(latitude)) * cos(radians(longitude) - radians(51.635287000000)) + sin( radians(-0.055728000000)) * sin(radians(latitude)))) AS distance
  2. FROM stations HAVING distance < 5
  3. ORDER BY distance
  4. LIMIT 0, 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement