fix queries for admin reports