USE skwiki_p;

​

SELECT

    a.actor_name, COUNT(*) as count

  FROM

    page p, revision rf, actor_user a

  WHERE

    rf.rev_page = p.page_id and

    a.actor_id = rf.rev_actor and

    p.page_namespace = 0 and

    -- p.page_is_redirect = 0 and

    rf.rev_timestamp >= DATE_FORMAT(DATE_SUB(now(), INTERVAL 1 MONTH), '%Y%m%d%H%i%s')

  GROUP BY

    a.actor_name

  ORDER BY

    count desc

  ;