fixed query for retrieving admissions