Test - Quarry

SQL

USE ckbwiki_p;

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(first_edit_bytes) AS TotalBytes
FROM (
  SELECT
    actor.actor_name,
    revision.rev_id,
    page.page_id,
    page.page_len AS first_edit_bytes,
    ROW_NUMBER() OVER (PARTITION BY page.page_id ORDER BY revision.rev_timestamp) AS edit_rank
  FROM revision
  JOIN (
    SELECT DISTINCT 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 revision.rev_id = first_revisions.first_revision_id
  JOIN actor ON actor.actor_id = revision.rev_actor
  JOIN page ON page.page_id = revision.rev_page
  WHERE page_namespace = 0
  AND page_is_redirect = 0
) AS first_edits
WHERE edit_rank = 1
GROUP BY actor_name;
SQL

Checking query status...
