Comparison of tagged semi-automated tool edits

SQL

SELECT -- Add the following columns...
    COUNT(CASE WHEN ct_tag_id = 7 THEN 1 END) as "Huggle",
    COUNT(CASE WHEN ct_tag_id = 7 THEN 1 END)/525600 as "Huggle RPM",
    COUNT(CASE WHEN ct_tag_id = 63 THEN 1 END) as "STiki",
    COUNT(CASE WHEN ct_tag_id = 63 THEN 1 END)/525600 as "STiki RPM",
    COUNT(CASE WHEN ct_tag_id = 577 THEN 1 END) as "RedWarn",
    COUNT(CASE WHEN ct_tag_id = 577 THEN 1 END)/525600 as "RedWarn RPM",
    COUNT(CASE WHEN ct_tag_id = 583 THEN 1 END) as "Twinkle",
    COUNT(CASE WHEN ct_tag_id = 583 THEN 1 END)/525600 as "Twinkle RPM"
FROM revision -- ... from all Wikipedia revisions
JOIN change_tag ON ct_rev_id = rev_id        -- Combines revision tags with the query
WHERE 
    rev_timestamp > DATE_FORMAT(DATE_ADD(NOW(), INTERVAL -1 YEAR), "%Y%m%d%H%i%s") AND (  -- Minus one year
        ct_tag_id = 7  -- HG
        OR ct_tag_id = 63  -- ST
        OR ct_tag_id = 577  -- RW
        OR ct_tag_id = 583  -- TW
    )
SQL

Checking query status...
