(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 COUNT(1) AS pages_with_disambig_but_not_redir FROM page
WHERE (page_namespace = 0 AND page_is_redirect = 0);
SELECT actor_user AS user_id, actor_name AS user_name, COUNT(1) AS user_articles, MAX(rev_timestamp) AS user_latestcreation FROM (
	SELECT rev_actor, MIN(rev_timestamp) AS rev_timestamp FROM revision
	LEFT JOIN (SELECT page_id FROM page WHERE page_namespace = 0 AND page_is_redirect = 0 LIMIT 10) AS pg ON revision.rev_page = pg.page_id
	WHERE (rev_page, rev_timestamp) IN (SELECT rev_page, MIN(rev_timestamp) FROM revision LEFT JOIN pg ON revision.rev_page = pg.page_id GROUP BY rev_page)
) AS uti
LEFT JOIN actor ON uti.rev_actor = actor.actor_id
GROUP BY user_id
-- HAVING user_articles >= @MIN_ARTICLES
ORDER BY user_articles DESC
-- LIMIT 2000;

SQL

Checking query status...