query.andWhere(`6371 * acos(
    cos(radians(:latitude)) *
    cos(radians(location.latitude)) *
    cos(radians(location.longitude) - radians(:longitude)) +
    sin(radians(:latitude)) *
    sin(radians(location.latitude))
) <= :radiusInKilometers`, {
    latitude,
    longitude,
    radiusInKilometers,
});