contribs in ns460 by upwizcampeditors and sysops

SQL

select rev_user_text, count(rev_user_text) num
from commonswiki_p.revision_userindex
join commonswiki_p.page
on commonswiki_p.page.page_namespace = 460
and commonswiki_p.revision_userindex.rev_page = commonswiki_p.page.page_id 

where commonswiki_p.revision_userindex.rev_user in (
  select commonswiki_p.user_groups.ug_user
  from commonswiki_p.user_groups
  where commonswiki_p.user_groups.ug_group = "upwizcampeditors"
)
group by 1
order by num desc
;

select rev_user_text, count(rev_user_text) num
from commonswiki_p.revision_userindex
join commonswiki_p.page
on commonswiki_p.page.page_namespace = 460 
and commonswiki_p.revision_userindex.rev_page = commonswiki_p.page.page_id

where commonswiki_p.revision_userindex.rev_user in (
  select commonswiki_p.user_groups.ug_user
  from commonswiki_p.user_groups
  where commonswiki_p.user_groups.ug_group = "sysop"
)
group by 1
order by num desc
;
SQL

Checking query status...
