(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_,
	rev_page AS rev_page_,
	rev_timestamp_
FROM (
	SELECT rev_actor, MIN(rev_timestamp) AS rev_timestamp_, rev_page 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;

SQL

Checking query status...