Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Base
.
Toggle Highlighting
SQL
select uawikimedia_p.user.user_name, uawikimedia_p.user.user_editcount as wmua, enwiki_p.user.user_editcount as enwp, ruwiki_p.user.user_editcount as ruwp, eswiki_p.user.user_editcount as eswp, dewiki_p.user.user_editcount as dewp, sum (uawikimedia_p.user.user_editcount, enwiki_p.user.user_editcount, ruwiki_p.user.user_editcount, dewiki_p.user.user_editcount) as sigma from uawikimedia_p.user join enwiki_p.user on enwiki_p.user.user_name = uawikimedia_p.user.user_name join ruwiki_p.user on ruwiki_p.user.user_name = uawikimedia_p.user.user_name join eswiki_p.user on eswiki_p.user.user_name = uawikimedia_p.user.user_name join dewiki_p.user on dewiki_p.user.user_name = uawikimedia_p.user.user_name where uawikimedia_p.user.user_editcount > 10 order by wmua desc
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...