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 COUNT(DISTINCT page_id) FROM revision

SQL

Checking query status...