Advertisement
Guest User

Untitled

a guest
Feb 26th, 2017
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. SELECT id, user_id,
  2. (6371 * acos(
  3. cos( radians(-30.053831) )
  4. * cos( radians( lat ) )
  5. * cos( radians( lng ) - radians(-51.191810) )
  6. + sin( radians(-30.053831) )
  7. * sin( radians( lat ) )
  8. )
  9. ) AS distancia
  10. FROM enderecos
  11. GROUP BY user_id
  12. HAVING distancia < 25
  13. ORDER BY distancia ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement