USE dewiki_p;

​

SELECT

    actor_name,

    COUNT(page_id) AS cnt

FROM

    page JOIN revision_userindex ON page_id=rev_page JOIN actor_revision ON actor_id=rev_actor

WHERE

    page_namespace=0

    AND page_is_redirect=0

    AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation')

    AND rev_parent_id=0

GROUP BY

    actor_name

ORDER BY

    cnt DESC

LIMIT 1000;