Test - Quarry

SQL

USE ckbwiki_p;

-- Main query to get user statistics based on the usernames from the specified page
SELECT
  ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, SUM(rev_len) DESC) AS Rank,
  CONCAT('[[User:', actor_name, '|', actor_name, ']]') AS UserName,
  COUNT(*) AS NumberOfArticles,
  SUM(rev_len) AS TotalBytes
FROM revision
JOIN (
  SELECT DISTINCT rev_page, MIN(rev_id) AS first_revision_id
  FROM revision
  WHERE rev_parent_id = 0
    AND rev_timestamp BETWEEN 20230101000000 AND 20230430235959
  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
JOIN pagelinks AS UserPage ON UserPage.pl_from = page.page_id AND UserPage.pl_namespace = 0 -- Join directly with pagelinks
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND rev_len >= 1000
  AND (
    SELECT COUNT(*)
    FROM pagelinks
    WHERE pl_from = page.page_id
    AND pl_namespace = 0
  ) > 1
GROUP BY actor_name
ORDER BY Rank;
SQL

Checking query status...
