USE plwikisource_p;

SELECT actor_name  FROM

(SELECT COUNT(*) AS n, actor_name

  FROM revision JOIN actor ON rev_actor = actor_id

                JOIN user_groups ON actor_user = ug_user

                JOIN page ON page_id = rev_page

 WHERE ug_group = 'editor' AND rev_timestamp > adddate(now(),-365) AND page_namespace % 2 = 0

  GROUP BY rev_actor

  HAVING n > 10) AS a

  order by n DESC

LIMIT 3000;

​