Toggle navigation
βeta
Home
New Query
Recent Queries
Discuss
Database tables
MediaWiki
Wikibase
Replicas browser and optimizer
Login
Fork
Fork of
AWB users
by
MBH
This query is marked as a draft
This query has been published
by
MBH
.
Toggle Highlighting
SQL
select count(*) c, ruwiki_p.user.user_name from ruwiki_p.revision join ruwiki_p.user on ruwiki_p.revision.rev_user=ruwiki_p.user.user_id join commonswiki_p.user on ruwiki_p.user.user_name=commonswiki_p.user.user_name join commonswiki_p.user_groups on commonswiki_p.user.user_id=commonswiki_p.user_groups.ug_user where commonswiki_p.user.user_id not in (select ug_user from commonswiki_p.user_groups where ug_group="filemover") and ruwiki_p.user.user_id not in (select ug_user from ruwiki_p.user_groups where ug_group like "%editor%") group by ruwiki_p.revision.rev_user order by c desc;
By running queries you agree to the
Labs ToS
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
All SQL code is licensed under
CC0 License
.
Checking query status...