Test - Quarry

SQL

USE ckbwiki_p;
SELECT
  user_name AS username,
  SUM(original_size) AS total_size
FROM (
  SELECT
    user_name,
    rev_len AS original_size
  FROM revision
  JOIN page ON page_id = rev_page
  JOIN actor ON actor_id = rev_actor
  JOIN user ON user_id = actor_user
  WHERE page_namespace = 0
    AND rev_timestamp = (
      SELECT MIN(rev_timestamp)
      FROM revision
      WHERE rev_page = page_id
    )
) AS first_revisions
JOIN (
  SELECT
    actor_name AS Username,
    COUNT(*) AS NumberOfArticles,
    SUM(page.page_len) AS TotalBytes,
    SUM(LENGTH(page.page_title)) AS TotalWords
  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
  GROUP BY actor_name
) AS article_stats
ON first_revisions.username = article_stats.Username
GROUP BY user_name;
SQL

Checking query status...
