(test) rowiki users by no. of articles created

Testing a version that uses distinct column names, since the usual one suddenly started freaking out.
Also, the results have been wrong since late February 2022 and I'm trying to investigate why.

SQL

USE rowiki_p;
/*
SELECT rev_actor, actor_user, actor_name, MIN(rev_timestamp)
INTO @rev_actor, @actor_user, @actor_name, @rev_timestamp
FROM revision
LEFT JOIN page ON revision.rev_page = page.page_id
LEFT JOIN actor ON revision.rev_actor = actor.actor_id
WHERE (page_id IS NOT NULL) AND (page_namespace = 0) AND (page_is_redirect = 0)
GROUP BY revision.rev_page
LIMIT 10;*/
WITH t AS (SELECT actor_id FROM actor LIMIT 10)
SELECT * FROM t;
/*
SELECT COUNT(DISTINCT rev_actor), actor_user INTO @no_distinct_ips
FROM (SELECT @rev_actor AS rev_actor, @actor_user AS actor_user)
WHERE actor_user IS NULL;

SELECT @no_distinct_ips AS no_distinct_ips, COUNT(@rev_actor) AS no_articles;

SELECT @actor_user AS user_id, @actor_name AS user_name, COUNT(1) AS user_articles, MAX(@rev_timestamp) AS user_latestcreation
GROUP BY user_id;*/

SQL

Checking query status...