Comparison of tagged semi-automated tool edits

SQL

-- =======================================================================
-- This query will check Wikipedia for all edits tagged with "RedWarn",
-- and find all users of RedWarn from these changes. This also includes
-- users who have used RedWarn previously but have since uninstalled
-- RedWarn. Since RedWarn is commonly used in conjunction with Twinkle,
-- this also counts all Twinkle edits by the users. This will also check
-- if the user is currently blocked or not.
-- =======================================================================
-- NOTES:
-- 
--  * Twinkle only started using the "twinkle" tag on September 2020.
--  * This includes users who have uninstalled RedWarn.
--  * This does not distinguish selfblocks.
--  * This checks for expanded RedWarn features (given if 30/500 passes.)
-- =======================================================================
-- Improved by RW developer Chlod, forked from AntiCompositeNumber's original
-- RW users script. Both versions released under CC0 (per Quarry terms).

USE enwiki_p; -- Use the English Wikipedia database.

SELECT -- Add the following columns...
    COUNT(CASE WHEN ct_tag_id = 7 THEN 1 END) as "Huggle",
    COUNT(CASE WHEN ct_tag_id = 577 THEN 1 END) as "RedWarn",
    COUNT(CASE WHEN ct_tag_id = 583 THEN 1 END) as "Twinkle"
FROM revision -- ... from all Wikipedia revisions
JOIN change_tag ON ct_rev_id = rev_id        -- Combines revision tags with the query
WHERE 
    ct_tag_id = 7
    OR ct_tag_id = 577
    OR ct_tag_id = 583    -- Only get edits tagged "RedWarn" or "twinkle"
SQL

Checking query status...
