Advertisement
Guest User

Untitled

a guest
Dec 14th, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT *, 3956 * 2 * ASIN(SQRT( POWER(SIN((" & Lat & " - abs(dest.lat)) * pi()/180 / 2),2) + COS(" & Lat & * pi()/180 ) * COS(abs(dest.lat) * pi()/180) * POWER(SIN((" & Lng & - dest.lng) * pi()/180 / 2), 2) )) AS distance
  2. FROM data__metar_stations AS dest
  3. ORDER BY distance
  4. LIMIT 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement