USE skwiki_p;

​

SELECT

    YEAR(rf.rev_timestamp) AS year,

    MONTH(rf.rev_timestamp) AS month,

    COUNT(*) AS count,

    SUM(COUNT(*)) OVER(ORDER BY YEAR(rf.rev_timestamp), MONTH(rf.rev_timestamp)) AS count_cumulative

  FROM

    page p, revision rf

  WHERE

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

    p.page_namespace = 0 and

    p.page_is_redirect = 0

  GROUP BY

    YEAR(rf.rev_timestamp), MONTH(rf.rev_timestamp)

  ORDER BY

    YEAR(rf.rev_timestamp), MONTH(rf.rev_timestamp)

  ;

​