Untitled query #87941

SQL

SELECT
    COUNT(*) AS total_edits,
    SUM(CASE WHEN ctd.ctd_name = 'mw-reverted' THEN 1 ELSE 0 END) AS mw_reverted_edits,
    SUM(CASE WHEN ctd.ctd_name in ('mw-undo','mw-rollback') THEN 1 ELSE 0 END) AS reverts,
FROM
    revision_userindex
JOIN
    actor_revision ON revision_userindex.rev_actor = actor_revision.actor_id
LEFT JOIN
    change_tag ON change_tag.ct_rev_id = revision_userindex.rev_id
LEFT JOIN
    change_tag_def AS ctd ON change_tag.ct_tag_id = ctd.ctd_id
WHERE
    actor_revision.actor_name = 'Zero0000'
    AND date(revision_userindex.rev_timestamp) BETWEEN '2023-01-01' AND '2023-01-31';
SQL

Checking query status...
