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
Count Count
.
Toggle Highlighting
SQL
USE dewiki_p; SELECT user_name, stb_all_edits FROM (SELECT rev_user as stb_user, COUNT(rev_id) AS stb_all_edits FROM revision_userindex INNER JOIN page on rev_page=page_id WHERE rev_user IN (SELECT user_id FROM user WHERE user_name in ('Wadis', 'A.Savin', 'Aalfons', 'Achim', 'AchimP', 'AFBorchert', 'Agathenon', 'Albinfo', 'Alinea', 'All', 'Alpöhi', 'Alraunenstern', 'Altkatholik62', 'Amberg', 'Ambross07', 'Amga', 'An-d', 'Andreas', 'Andropov', 'Anidaat', 'Anti.', 'Appelboim', 'Arabsalam', 'Armin', 'Artmax', 'Artregor', 'Aschmidt', 'Atomiccocktail')) AND page_namespace=0 GROUP BY rev_user) AS tab INNER JOIN user ON stb_user=user_id
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...