Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT id, user_id,
- (6371 * acos(
- cos( radians(-30.053831) )
- * cos( radians( lat ) )
- * cos( radians( lng ) - radians(-51.191810) )
- + sin( radians(-30.053831) )
- * sin( radians( lat ) )
- )
- ) AS distancia
- FROM enderecos
- GROUP BY user_id
- HAVING distancia < 25
- ORDER BY distancia ASC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement