Article Distribution by Size Bucket

SQL

#SELECT floor(page_len/100) * 100 AS bucket, COUNT(page_id) AS cnt FROM page WHERE 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;
#SELECT floor(p.page_len/100) * 100 AS bucket, count(r.rev_page) AS cnt FROM revision r INNER JOIN page p ON p.page_id = r.rev_page WHERE page_namespace=0 AND page_is_redirect!=1 AND r.rev_page NOT IN (SELECT pp_page FROM page_props WHERE pp_propname='disambiguation') GROUP BY bucket;
SELECT floor(p.page_len/100) * 100 AS bucket, count(r.rev_page) AS cnt FROM revision r INNER JOIN page p ON p.page_id = r.rev_page WHERE p.page_namespace=0 AND p.page_is_redirect!=1 AND r.rev_timestamp > 20180101000000 GROUP BY bucket
SQL

Checking query status...
