SELECT

    SUBSTR(rev_timestamp, 1, 6) AS bucket,

    COUNT(rev_id) AS cnt

FROM

    revision JOIN page ON page_id=rev_page

WHERE

    page_namespace=0

--    AND rev_minor_edit=1

-- WHERE

--     rev_timestamp>20140000000000

--     AND rev_timestamp<20141300000000

--     page_namespace=0

--     AND page_is_redirect!=1

--     AND page_id NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation')

GROUP BY

    bucket;

​

​