SELECT count(*) FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND rc_source = 'mw.edit' LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%';

639,237

SELECT count(*) FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND rc_source = 'mw.edit' LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' AND rc_id IS NULL;

69,971 10.9%


SELECT count(*) FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND rc_source = 'mw.edit' LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' AND rev_parent_id=0;

64,735

SELECT count(*) FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND rc_source = 'mw.edit' LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' AND rev_parent_id=0 AND rc_id IS NULL;

64,736 ~100%