Reverted contribution rate

This query is marked as a draft This query has been published by Tgr.

Calculates how often the contribution of a group of users get reverted, and lists them most reverted first. Might be useful for evaluating campaigns.
Note that deleted edits are not counted (as they aren't publicly available).

To use, press "Fork" on the top right, then edit the list of names (in two places!).

SQL

SELECT
    actor_name `name`,
    COUNT(*) `edits`,
    ( ct_tag_id IS NOT NULL ) `reverted `
FROM
    revision
    JOIN actor ON rev_actor = actor_id
    LEFT JOIN change_tag ON rev_id = ct_rev_id
        AND ct_tag_id = ( SELECT ctd_id FROM change_tag_def WHERE ctd_name = 'mw-reverted' )
WHERE
    actor_name IN ( 'Tgr' )
    AND actor_user IS NOT NULL
GROUP BY
    actor_name,
    ct_tag_id IS NOT NULL
;

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.

SQL

Checking query status...