Fork of
Reverts by users in trwiki
by Stultiwikia
This query is marked as a draft
This query has been published
by MNeisler (WMF).
SQL
AخA
SELECT actor_name as user,
COUNT(*) as cnt
FROM revision
JOIN change_tag
ON rev_id = ct_rev_id
JOIN actor
ON actor_id = rev_actor
WHERE ct_tag_id =
(SELECT ctd_id FROM change_tag_def
WHERE ctd_name = 'mw-reverted')
GROUP BY user
ORDER BY cnt DESC
LIMIT 1000;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.