Test - Quarry

SQL

USE ckbwiki_p;

SELECT
  actor_name AS Username,
  COUNT(*) AS NumberOfArticles,
  SUM(first_revisions.first_revision_bytes) AS TotalBytes,
  SUM(LENGTH(page_title)) AS TotalWords
FROM page
JOIN (
  SELECT
    rev_page,
    MIN(rev_id) AS first_revision_id,
    SUM(LENGTH(old_text)) AS first_revision_bytes
  FROM revision
  JOIN page ON page_id = rev_page
  JOIN actor ON actor_id = rev_actor
  JOIN text ON rev_text_id = old_id
  WHERE rev_parent_id = 0
    AND rev_timestamp BETWEEN '2023-01-01' AND '2023-05-01'
    AND page_namespace = 0
    AND page_is_redirect = 0
  GROUP BY rev_page
) AS first_revisions
ON page_id = first_revisions.rev_page
JOIN actor ON actor_id = first_revisions.first_revision_actor
GROUP BY actor_name;
SQL

Checking query status...
