rowiki users by no. of articles created (min. 10)

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 /*MIN(rev_id) AS rev_id,*/ rev_actor, MIN(rev_timestamp) AS rev_timestamp FROM revision
	LEFT 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*/
	WHERE (/*rev_parent_id = 0 AND*/ page_namespace = 0 AND page_is_redirect = 0 /*AND pp_propname IS NULL*/)
	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...
