Move to a LEFT JOIN'd scope for mapping counts

Saves > 100 queries for FCO sites and other large orgs