Untitled query #87941

SQL

SELECT
    p.page_namespace,
    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
JOIN
    page AS p ON p.page_id = revision_userindex.rev_page
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 = 'Selfstudier'
--    AND p.page_namespace = 0
    AND date(revision_userindex.rev_timestamp) BETWEEN '2023-10-07' AND '2024-11-18';
SQL

Checking query status...
