SELECT *, (6371 *
        acos(
            cos(radians({{GEO.LAT}})) *
            cos(radians(lat)) *
            cos(radians({{GEO.LONG}}) - radians(lng)) +
            sin(radians({{GEO.LAT}})) *
            sin(radians(lat))
        )) AS distance
FROM tabela LOCATION distance <= {{RANGE.KM}}