USE plwikisource_p;

SELECT actor_name, Now()-10000000000 as datum  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 > Now()-10000000000  AND page_namespace % 2 = 0

  GROUP BY rev_actor

  HAVING n > 50) AS a

  order by n DESC

LIMIT 3000;

​