USE ltwiki_p;

SELECT 

    COUNT(revision.rev_actor) as cnt,

    actor.actor_name

FROM page 

JOIN revision 

ON page.page_id=revision.rev_page 

JOIN actor 

ON revision.rev_actor=actor.actor_id     

WHERE 

    page.page_namespace=0 

    AND page.page_is_redirect=0 

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

    AND revision.rev_parent_id=0 

GROUP BY revision.rev_actor

ORDER BY cnt 

DESC LIMIT 220;