nlwiki Authors who started the most articles

SQL

SELECT COUNT(actor_name) AS `count`, actor_name
FROM page, revision, actor
WHERE
	page_namespace=0 AND
	page_is_redirect=0 AND
    page_is_new=1 AND
    NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation') AND
    page_latest=rev_id AND
    rev_actor=actor_id
GROUP BY actor_name
ORDER BY `count` DESC
LIMIT 50

/*SELECT page_title, rev_timestamp, rev_len, actor_name
FROM page, revision, actor
WHERE
	page_namespace=0 AND
	page_is_redirect=0 AND
    page_is_new=1 AND
    NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation') AND
    page_latest=rev_id AND
    rev_actor=actor_id
LIMIT 10*/
SQL

Checking query status...
