SELECT

  page_title,

  rev_page                  AS page_id,

  count(*)                  AS revisions,

  count(distinct rev_actor) AS editors,

  sum(rev_len)              AS size,

  rev_timestamp             AS created

FROM revision 

INNER JOIN page ON page_id = rev_page

​

INNER JOIN actor ON actor_id = rev_actor

WHERE rev_parent_id = 0

      AND page_namespace = 0

      AND page_is_redirect = 0

    # EXCLUDE IPSs

    AND actor_user IS NOT NULL

    AND rev_timestamp < (NOW() - INTERVAL 30 DAY)

    #AND rev_timestamp > (NOW() - INTERVAL 3650 DAY)

    AND page.page_namespace = 0

GROUP BY rev_page

ORDER BY editors DESC

LIMIT 10;