consolidated queries for processing activities in the admin screen