(test) rowiki users by no. of articles created

SQL

SELECT COUNT(1) AS pages_with_disambig_but_not_redir FROM page
WHERE (page_namespace = 0 AND page_is_redirect = 0);
SELECT
	CASE WHEN user_articles_ >= 10 THEN user_id_ ELSE -2 END AS user_id_final,
	CASE WHEN user_articles_ >= 10 THEN user_name_ ELSE CONCAT("<", COUNT(1), " registered users under the threshold>") END AS user_name_final,
	CASE WHEN user_articles_ >= 10 THEN user_articles_ ELSE SUM(user_articles_) END AS user_articles_final,
	CASE WHEN user_articles_ >= 10 THEN user_latestcreation_ ELSE MAX(user_latestcreation_) END AS user_latestcreation_final
FROM (
	SELECT
		CASE WHEN user_id__ IS NULL THEN -1 ELSE user_id__ END AS user_id_,
		CASE
			WHEN user_id__ IS NULL THEN CONCAT("<", COUNT(DISTINCT actor_id__), " unregistered users>")
			ELSE user_name__
		END AS user_name_,
		COUNT(user_articles__) AS user_articles_,
		MAX(rev_timestamp_) AS user_latestcreation_
	FROM (
		SELECT
			actor_id AS actor_id__
			actor_user AS user_id__,
			actor_name AS user_name__,
			1 AS user_articles__,
			rev_timestamp_
		FROM (
			SELECT rev_actor, rev_timestamp_ FROM (
				-- SELECT rev_actor, MIN(rev_timestamp) AS rev_timestamp_ FROM revision
				SELECT rev_actor, rev_timestamp AS rev_timestamp_, rev_page FROM revision
				GROUP BY rev_page
			) AS revtable
			LEFT JOIN page ON revtable.rev_page = page.page_id
			WHERE (page_namespace = 0 AND page_is_redirect = 0)
		) AS uti
		LEFT JOIN actor ON uti.rev_actor = actor.actor_id
	) AS uti_
	GROUP BY user_id_
) AS uti__
GROUP BY user_id_final
ORDER BY user_articles_final DESC;
SQL

Checking query status...
