No of articles on rowiki

SQL

USE rowiki_p;
SELECT rev_actor AS actor_id, actor_user, actor_name, COUNT(page_id) AS actor_createdpages FROM (
	SELECT MAX(rev_id) AS rev_id, page_id, rev_actor, actor_user, actor_name FROM revision
	INNER JOIN page ON revision.rev_page = page.page_id
	/*LEFT JOIN (
		SELECT TRUE AS pp_disambig FROM page_props
		WHERE pp_propname = "disambiguation"
	) AS pp ON revision.rev_page*/
	LEFT JOIN actor ON revision.rev_actor = actor.actor_id
	WHERE (rev_parent_id = 0 AND page_namespace = 0 AND page_is_redirect = 0/* AND pp_disambig IS NULL*/)
	GROUP BY rev_page
) AS act
GROUP BY actor_user
ORDER BY actor_createdpages DESC
LIMIT 10000;
SQL

Checking query status...
