Untitled query #87941

SQL

-- Define the editor name, start date, and end date
SET @editor_name = 'Zero0000'; -- Replace with the actual editor's username
SET @start_date = '2023-01-01 00:00:00'; -- Replace with the desired start date
SET @end_date = '2023-12-31 23:59:59'; -- Replace with the desired end date;

-- Query to count total edits and edits with the mw-reverted tag
SELECT 
    COUNT(*) AS total_edits,
    SUM(CASE WHEN ct.ctd_id IS NOT NULL THEN 1 ELSE 0 END) AS mw_reverted_edits
FROM 
    revision
JOIN 
    actor ON revision.rev_actor = actor.actor_id
LEFT JOIN 
    change_tag_def AS ctd ON ctd.ctd_name = 'mw-reverted'
LEFT JOIN 
    change_tag AS ct ON ct.ct_tag_id = ctd.ctd_id AND ct.ct_rev_id = revision.rev_id
WHERE 
    actor.actor_name = @editor_name
    AND revision.rev_timestamp BETWEEN @start_date AND @end_date;
SQL

Checking query status...
