Paste P86762

Recent changes date loss by rev_parent_id, enwiktionary (T364245)
ActivePublic
Actions

Authored by Krinkle on Dec 31 2025, 8:15 AM.

Tags

None

Referenced Files

	F71387669: Recent changes date loss by rev_parent_id, enwiktionary (T364245)
	Dec 31 2025, 8:15 AM

Subscribers

None

	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%

Event Timeline

Krinkle created this paste.Dec 31 2025, 8:15 AM