USE trwiki_p;

​

SELECT

    a.actor_name, COUNT(*) as count

  FROM

    page p, revision rf, actor_user a

  WHERE

    rf.rev_page = p.page_id and rf.rev_parent_id = 0 and

    a.actor_id = rf.rev_actor and

    p.page_namespace = 0 and

    p.page_is_redirect = 0

  GROUP BY

    a.actor_name

  ORDER BY

    count desc

  ;