Test - Quarry

SQL

USE ckbwiki_p;
SELECT
  users.user_name AS username,
  COALESCE(SUM(revision.rev_len), 0) AS original_size
FROM actor AS users
LEFT 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 users.actor_id = first_revisions.first_revision_id
LEFT JOIN revision
ON first_revisions.first_revision_id = revision.rev_id
LEFT JOIN page
ON revision.rev_page = page.page_id
WHERE page_namespace = 0
GROUP BY users.user_name;
SQL

Checking query status...
