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
Gnoeee
.
Edit count of users in a category.
Toggle Highlighting
SQL
SELECT user_id, user_name, user_editcount FROM user WHERE user_name IN ( SELECT REPLACE(REPLACE(page_title, 'User:', ''), ' ', '') AS user_name FROM categorylinks JOIN page ON page_id = cl_from LEFT JOIN actor ON actor.actor_name = REPLACE(page_title, 'User:', '') WHERE cl_to = 'User_pa-N'; ) AND user_editcount > 50000 ORDER BY user_editcount 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...