radius.sql

SELECT id, address, datetime, price, ROUND(6371 * acos(cos(radians(1.329380)) * cos(radians(event_lat)) * cos(radians(event_lng) - radians(103.775595)) + sin(radians(1.329380)) * sin(radians(event_lat))), 3) as distance
FROM jobs
WHERE (6371 * acos(cos(radians(1.329380)) * cos(radians(event_lat)) * cos(radians(event_lng) - radians(103.775595)) + sin(radians(1.329380)) * sin(radians(event_lat)))) < 50
ORDER BY distance DESC;

Select details and haversine formula in kilometres rounded to nearest metre, from jobs table, where the radius given by haversine is less than 50km, sort by distance descending