This splits most of the unit tests in the Dashboard test suite into a

global site test, a Local Site test, and a global site + Local Sites in

the database test.
This gives us thorough query coverage, which unveils a number of

sub-optimal queries that will need to be addressed in upcoming changes.
The queries are intentionally verbose right now, with no query-building

being shared across tests, and with the query-by-query breakdowns

removed. This is intentional, as upcoming work is expected to heavily

impact these queries.

Unit tests pass.