Test - Quarry

SQL

USE ckbwiki_p;
SELECT
  actor_name AS username,
  COUNT(*) AS NumberOfArticles,
  SUM(rev_len) AS TotalBytes,
  SUM(LENGTH(TRIM(BOTH ' ' FROM first_rev.text)) - LENGTH(REPLACE(TRIM(BOTH ' ' FROM first_rev.text), ' ', '')) + 1) AS TotalWords
FROM (
  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
JOIN revision AS first_rev ON first_rev.rev_id = first_revisions.first_revision_id
JOIN actor ON actor.actor_id = first_rev.rev_actor
WHERE first_rev.page_namespace = 0
  AND first_rev.page_is_redirect = 0
GROUP BY actor_name;
SQL

Checking query status...
