Recent changes date loss by page_namespace, nlwiki (T364245)
ActivePublic
Actions

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

Tags

None

Referenced Files

	F71387788: Recent changes date loss by page_namespace, nlwiki (T364245)
	Dec 31 2025, 8:21 AM

	F71387564: Recent changes date loss by page_namespace, nlwiki (T364245)
	Dec 31 2025, 8:01 AM

Subscribers

None

	(nlwiki)> SELECT count(*), page_namespace 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%' GROUP BY page_namespace;

	+----------+----------------+
	\| count(*) \| page_namespace \|
	+----------+----------------+
	\| 143910 \| 0 \|
	\| 2425 \| 1 \|
	\| 9925 \| 2 \|
	\| 4013 \| 3 \|
	\| 6208 \| 4 \|
	\| 114 \| 5 \|
	\| 23 \| 8 \|
	\| 20 \| 9 \|
	\| 2834 \| 10 \|
	\| 150 \| 11 \|
	\| 438 \| 12 \|
	\| 15 \| 13 \|
	\| 975 \| 14 \|
	\| 7 \| 15 \|
	\| 624 \| 100 \|
	\| 19 \| 101 \|
	\| 149 \| 828 \|
	\| 30 \| 829 \|
	\| 49 \| 1728 \|
	+----------+----------------+
	19 rows in set

	(nlwiki)> SELECT count(*), page_namespace 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 GROUP BY page_namespace;
	+----------+----------------+
	\| count(*) \| page_namespace \|
	+----------+----------------+
	\| 7071 \| 0 \| Main 5% loss
	\| 506 \| 1 \| Talk 20% loss
	\| 392 \| 2 \| User 4% loss
	\| 1005 \| 3 \| User_talk 25% loss
	\| 148 \| 4 \| Project 2% loss
	\| 6 \| 5 \|
	\| 2 \| 8 \|
	\| 300 \| 10 \| Template 10% loss
	\| 5 \| 11 \|
	\| 8 \| 12 \|
	\| 424 \| 14 \| Category 42% loss
	\| 6 \| 15 \|
	\| 8 \| 100 \|
	\| 16 \| 828 \|
	\| 1 \| 829 \|
	\| 2 \| 1728 \|
	+----------+----------------+
	16 rows in set

Event Timeline

	(nlwiki)> SELECT count(*), page_namespace 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%' GROUP BY page_namespace;

	+----------+----------------+
	\| count(*) \| page_namespace \|
	+----------+----------------+
	\| 143910 \| 0 \|
	\| 2425 \| 1 \|
	\| 9925 \| 2 \|
	\| 4013 \| 3 \|
	\| 6208 \| 4 \|
	\| 114 \| 5 \|
	\| 23 \| 8 \|
	\| 20 \| 9 \|
	\| 2834 \| 10 \|
	\| 150 \| 11 \|
	\| 438 \| 12 \|
	\| 15 \| 13 \|
	\| 975 \| 14 \|
	\| 7 \| 15 \|
	\| 624 \| 100 \|
	\| 19 \| 101 \|
	\| 149 \| 828 \|
	\| 30 \| 829 \|
	\| 49 \| 1728 \|
	+----------+----------------+
	19 rows in set

	(nlwiki)> SELECT count(*), page_namespace 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 GROUP BY page_namespace;
	+----------+----------------+
	\| count(*) \| page_namespace \|
	+----------+----------------+
	\| 7071 \| 0 \| Main 5% loss
	\| 506 \| 1 \| Talk 20% loss
	\| 392 \| 2 \| User 4% loss
	\| 1005 \| 3 \| User_talk 25% loss
	\| 148 \| 4 \| Project 2% loss
	\| 6 \| 5 \|
	\| 2 \| 8 \|
	\| 300 \| 10 \| Template 10% loss
	\| 5 \| 11 \|
	\| 8 \| 12 \|
	\| 424 \| 14 \| Category 42% loss
	\| 6 \| 15 \|
	\| 8 \| 100 \|
	\| 16 \| 828 \|
	\| 1 \| 829 \|
	\| 2 \| 1728 \|
	+----------+----------------+
	16 rows in set