Total RedWarn/Ultraviolet edits, past month

SQL

-- ==================================================================================
-- 2023-12-14 - Updated by [[User:Sportzpikachu]]
--     * Check UV instead of TW
--     * Check for edits in past month
--     * Require at least 1 RW/UV edit in past month
--     * Additional query for count of users with more UV edits than RW in past month
-- 2024-02-01 - Adapted to count total RW/UV edits in past month
-- Improved by RW developer Chlod, forked from AntiCompositeNumber's original
-- RW users script. Both versions released under CC0 (per Quarry terms).

SET @RW_TAG_ID := 577, @UV_TAG_ID := 618, @TW_TAG_ID := 583; -- 577 = RW, 618 = UV, 583 = TW

SELECT
    COUNT(IF(ct_tag_id = @RW_TAG_ID, 1, NULL)) as RW_Count,
    COUNT(IF(ct_tag_id = @UV_TAG_ID, 1, NULL)) as UV_Count
    FROM revision_userindex
    JOIN change_tag ON ct_rev_id = rev_id
    WHERE (ct_tag_id = @RW_TAG_ID OR ct_tag_id = @UV_TAG_ID) AND rev_timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MONTH);
SQL

Checking query status...
