Comparison of tagged semi-automated tool edits

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

A comparison of tagged semi-automated tool edits, based on the edits from 2020.

SQL

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 
    rev_timestamp > 20200101000000 AND (
        ct_tag_id = 7
        OR ct_tag_id = 577
        OR ct_tag_id = 583
    )

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...