akbertram/activityinfo — comment on commit c8fde5f7de077415b19e3085aaf7714a549cde7d
File:  line 0
By akbertram:

This seems to have broken a number of related tests--
And it does look like this query is showing ALL sites in every database that has at least one public activity--
What we want is sites that belong to published activities -- so it should be just

"Activity.published > 0" rather than
" UserDatabase.DatabaseId in (select pa.DatabaseId from activity pa where pa.published>0)"