I want to change this raw query to laravel eloquent
Please help
SELECT * FROM (SELECT id, name, address, phone, latitude, longitude, (' . $circle_radius . ' * acos(cos(radians(' . $lat . ')) * cos(radians(latitude)) * cos(radians(longitude) - radians(' . $lng . ')) + sin(radians(' . $lat . ')) * sin(radians(latitude)))) AS distance FROM candidates) AS distances WHERE distance < ' . $max_distance . ' ORDER BY distance OFFSET 0 LIMIT 20
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire