ukwiki Authors who started the most articles

Fork of ukwiki Authors who started the most articles by AntonProtsiuk (WMUA)

This query is marked as a draft This query has been published by Nemoralis.

SQL

SELECT COUNT(actor_name) AS `count`, actor_name
FROM revision, page, actor
WHERE
	rev_parent_id=0 AND
    rev_page=page_id AND
	page_namespace=0 AND
	page_is_redirect=0 AND
    NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation') AND
    rev_actor=actor_id
GROUP BY actor_name
ORDER BY `count` DESC
LIMIT 25
/*SELECT page_title, rev_timestamp, rev_len, actor_name
FROM revision, page, actor
WHERE
	rev_parent_id=0 AND
    rev_page=page_id AND
	page_namespace=0 AND
	page_is_redirect=0 AND
    NOT EXISTS (SELECT * FROM page_props WHERE pp_page=page_id AND pp_propname='disambiguation') AND
    rev_actor=actor_id
LIMIT 10*/

SQL

Checking query status...