(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

SELECT COUNT(1) AS pages_with_disambig_but_not_redir FROM page
WHERE (page_namespace = 0 AND page_is_redirect = 0);
SELECT
  		rev_actor AS actor_id_,
		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_
ORDER BY user_articles_ DESC;

SQL

Checking query status...