Test - Quarry

SQL

USE ckbwiki_p;

-- Subquery to get the first edit for each article
WITH FirstEdits AS (
  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
)

-- Query to retrieve the summation of the original sizes for all articles
SELECT
  user.user_name AS username,
  COUNT(*) AS NumberOfArticles,
  SUM(FirstEdits.first_revision_size) AS TotalOriginalBytes
FROM (
  SELECT
    rev_id AS first_revision_id,
    rev_page AS first_revision_page,
    rev_len AS first_revision_size
  FROM revision
  WHERE rev_id IN (SELECT first_revision_id FROM FirstEdits)
) AS FirstEdits
JOIN actor ON actor.actor_id = (SELECT rev_actor FROM revision WHERE rev_id = FirstEdits.first_revision_id)
JOIN user ON user.user_id = actor.actor_user
GROUP BY user.user_name;
SQL

Checking query status...
