Hi, I would like to replicate this query using .NET Core 3.1, Nest 7.10.0 and Elasticsearch 7.9.3
SELECT name, lat, lon, (6371 * acos(cos(radians(41.671958)) * cos(radians(lat)) * cos(radians(lon) - radians(-3.685049)) + sin(radians(41.671958)) * sin(radians(lat))))
HAVING distance < 70
ORDER BY distance;
name, lat and lon are fields from the db.