updated the adherence queries