Fixed query to get mandator roles (added mandator id to where clause).