Test - Quarry

SQL

USE ckbwiki_p;

SELECT
  ROW_NUMBER() OVER (ORDER BY (0.5 * (NumberOfArticles / MaxArticles) + 0.5 * (TotalBytes / MaxBytes)) DESC) AS Rank,
  CONCAT('[[User:', actor_name, '|', actor_name, ']]') AS UserName,
  COUNT(*) AS NumberOfArticles,
  SUM(rev_len) AS TotalBytes,
  0.5 * (NumberOfArticles / MaxArticles) AS ArticlesScore,
  0.5 * (TotalBytes / MaxBytes) AS BytesScore,
  (0.5 * (NumberOfArticles / MaxArticles) + 0.5 * (TotalBytes / MaxBytes)) AS TotalScore
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 20090101000000 AND 20231021000000
  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 (
  SELECT pl_title
  FROM pagelinks
  WHERE pl_from = 157289
    AND pl_namespace = 2
) AS UserPage
ON actor_name LIKE UserPage.pl_title
JOIN (
  SELECT
    MAX(COUNT(*)) AS MaxArticles,
    MAX(SUM(rev_len)) AS MaxBytes
  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 20090101000000 AND 20231021000000
    GROUP BY rev_page
  ) AS first_revisions
  ON revision.rev_id = first_revisions.first_revision_id
) AS MaxValues
WHERE page_namespace = 0
  AND page_is_redirect = 0
  AND rev_len >= 0
  AND (
    SELECT COUNT(*)
    FROM pagelinks
    WHERE pl_from = page.page_id
    AND pl_namespace = 0
  ) >= 0
GROUP BY actor_name
ORDER BY Rank;
SQL

Checking query status...
