Advertisement
Guest User

Untitled

a guest
Sep 26th, 2017
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.29 KB | None | 0 0
  1. SELECT id,nombre_local ( 6371 * acos( cos( radians(latitud_punto) ) * cos( radians( lat ) ) * cos( radians( lng ) - radians(longitud_punto) ) + sin( radians(latitud_punto) ) * sin( radians( lat ) ) ) ) AS distance FROM markers HAVING distance < distancia_radio ORDER BY distance LIMIT 0 , 10;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement