Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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