contribs in ns460 by upwizcampeditors and sysops

SQL

select rev_user_text, count(*)
from commonswiki_p.revision_userindex
join commonswiki_p.page
on commonswiki_p.revision_userindex.rev_page = commonswiki_p.page.page_id

where commonswiki_p.revision_userindex.rev_user in (
  select distinct commonswiki_p.user_groups.ug_user
  from commonswiki_p.user_groups
  where commonswiki_p.user_groups.ug_group = "upwizcampeditors"
) and commonswiki_p.page.page_namespace = 460
;


select distinct commonswiki_p.user_groups.ug_user from commonswiki_p.user_groups where commonswiki_p.user_groups.ug_group = "upwizcampeditors"

SQL

Checking query status...