(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 actor_user AS user_id, actor_name AS user_name, COUNT(1) AS user_articles, MAX(rev_timestamp) AS user_latestcreation FROM (
	SELECT MAX(rev_id) AS rev_id, rev_actor, rev_parent_id, actor_user, actor_name, rev_timestamp FROM revision
	INNER JOIN page ON revision.rev_page = page.page_id
	/*LEFT JOIN (
		SELECT pp_page, pp_propname FROM page_props
		WHERE pp_propname = "disambiguation"
	) AS pp ON revision.rev_page = pp.pp_page*/
	LEFT JOIN actor ON revision.rev_actor = actor.actor_id
	GROUP BY rev_page
	HAVING (rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0 /*AND pp_propname IS NULL*/)
) AS utilizatori
GROUP BY user_id
HAVING user_articles >= 10
ORDER BY user_articles DESC
LIMIT 2000;

SQL

Checking query status...