Test - Quarry

SQL

USE ckbwiki_p;

SELECT actor_name AS Username, COUNT(*) AS NumberOfArticles,
       SUM(page_len) AS TotalBytes
FROM page
JOIN (
    SELECT rev_page, MIN(rev_id) AS first_revision_id
    FROM revision
    WHERE rev_parent_id = 0
    AND DATE(rev_timestamp) BETWEEN '2023-01-01' AND '2023-05-01'
    GROUP BY rev_page
) AS first_revisions ON page_id = first_revisions.rev_page
JOIN revision ON page_id = revision.rev_page AND first_revision_id = revision.rev_id
JOIN actor ON revision.rev_actor = actor.actor_id
WHERE page_namespace = 0
GROUP BY actor_name;
SQL

Checking query status...
