Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
- FROM stations HAVING distance < 5
- ORDER BY distance
- LIMIT 0, 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement