Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Count fixes in Wikipedia:Correct typos in one click
by
Uziel302
This query is marked as a draft
This query has been published
by
Uziel302
.
Toggle Highlighting
SQL
SELECT actor_name AS contributor, COUNT(*) AS fixes FROM revision LEFT JOIN comment ON rev_comment_id=comment_id LEFT JOIN actor ON rev_actor=actor_id WHERE rev_page IN (60533818,62053073,61925999,61926002,61926007,61926012,61926014,62002342,62002343,62002345,62002348,62002349,61925967,62057349,61925968,61925974,61925980,61925985,61925989,61925991,61925997) AND comment_text LIKE "% fixed!" GROUP BY rev_actor ORDER BY fixes 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...