query and remove aggregation