(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 page ON revision.rev_page = page.page_id
	WHERE (page_namespace = 0 AND page_is_redirect = 0)
	GROUP BY revision.rev_page
) AS uti
LEFT JOIN actor ON uti.rev_actor = actor.actor_id
GROUP BY user_id
-- HAVING user_articles >= 10
ORDER BY user_articles DESC
-- LIMIT 2000;
*/

SQL

Checking query status...