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

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

Tags

None

Referenced Files

	F71387642: Recent changes date loss by page_namespace, enwiktionary (T364245)
	Dec 31 2025, 8:09 AM

	F71387630: Recent changes date loss by page_namespace, enwiktionary (T364245)
	Dec 31 2025, 8:08 AM

Subscribers

None

	(enwiktionary)> 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 \|
	+----------+----------------+
	\| 576073 \| 0 \|
	\| 1299 \| 1 \|
	\| 4554 \| 2 \|
	\| 1524 \| 3 \|
	\| 5422 \| 4 \|
	\| 88 \| 5 \|
	\| 46 \| 8 \|
	\| 28 \| 9 \|
	\| 15887 \| 10 \|
	\| 165 \| 11 \|
	\| 3 \| 12 \|
	\| 18885 \| 14 \|
	\| 34 \| 15 \|
	\| 1690 \| 100 \|
	\| 36 \| 101 \|
	\| 505 \| 106 \|
	\| 3 \| 108 \|
	\| 524 \| 110 \|
	\| 1 \| 111 \|
	\| 579 \| 114 \|
	\| 6697 \| 118 \|
	\| 95 \| 119 \|
	\| 4948 \| 828 \|
	\| 115 \| 829 \|
	+----------+----------------+
	24 rows

	wikiadmin2023@10.64.16.239(enwiktionary)> 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 \|
	+----------+----------------+
	\| 46363 \| 0 \| Main 8% loss
	\| 547 \| 1 \| Talk 42% loss
	\| 607 \| 2 \| User 13% loss
	\| 385 \| 3 \|
	\| 250 \| 4 \|
	\| 8 \| 5 \|
	\| 2 \| 8 \|
	\| 7 \| 9 \|
	\| 1388 \| 10 \| Template 8% loss
	\| 53 \| 11 \|
	\| 18733 \| 14 \| Category 99% loss
	\| 13 \| 15 \|
	\| 505 \| 100 \|
	\| 9 \| 101 \|
	\| 79 \| 106 \|
	\| 1 \| 108 \|
	\| 57 \| 110 \|
	\| 1 \| 111 \|
	\| 200 \| 114 \|
	\| 395 \| 118 \|
	\| 45 \| 119 \|
	\| 292 \| 828 \|
	\| 14 \| 829 \|
	+----------+----------------+
	23 rows in set (4.108 sec)

Event Timeline

Krinkle edited the content of this paste. (Show Details)

	(enwiktionary)> 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 \|
	+----------+----------------+
	\| 576073 \| 0 \|
	\| 1299 \| 1 \|
	\| 4554 \| 2 \|
	\| 1524 \| 3 \|
	\| 5422 \| 4 \|
	\| 88 \| 5 \|
	\| 46 \| 8 \|
	\| 28 \| 9 \|
	\| 15887 \| 10 \|
	\| 165 \| 11 \|
	\| 3 \| 12 \|
	\| 18885 \| 14 \|
	\| 34 \| 15 \|
	\| 1690 \| 100 \|
	\| 36 \| 101 \|
	\| 505 \| 106 \|
	\| 3 \| 108 \|
	\| 524 \| 110 \|
	\| 1 \| 111 \|
	\| 579 \| 114 \|
	\| 6697 \| 118 \|
	\| 95 \| 119 \|
	\| 4948 \| 828 \|
	\| 115 \| 829 \|
	+----------+----------------+
	24 rows

	wikiadmin2023@10.64.16.239(enwiktionary)> 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 \|
	+----------+----------------+
	\| 46363 \| 0 \| Main 8% loss
	\| 547 \| 1 \| Talk 42% loss
	\| 607 \| 2 \| User 13% loss
	\| 385 \| 3 \|
	\| 250 \| 4 \|
	\| 8 \| 5 \|
	\| 2 \| 8 \|
	\| 7 \| 9 \|
	\| 1388 \| 10 \| Template 8% loss
	\| 53 \| 11 \|
	\| 18733 \| 14 \| Category 99% loss
	\| 13 \| 15 \|
	\| 505 \| 100 \|
	\| 9 \| 101 \|
	\| 79 \| 106 \|
	\| 1 \| 108 \|
	\| 57 \| 110 \|
	\| 1 \| 111 \|
	\| 200 \| 114 \|
	\| 395 \| 118 \|
	\| 45 \| 119 \|
	\| 292 \| 828 \|
	\| 14 \| 829 \|
	+----------+----------------+
	23 rows in set (4.108 sec)