(nlwiki)> SELECT COUNT(*), page_namespace FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND (rc_source = 'mw.edit' OR rc_source = 'mw.new') LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' GROUP BY page_namespace;
+----------+----------------+
| COUNT(*) | page_namespace |
+----------+----------------+
| 144011 | 0 |
| 2425 | 1 |
| 9936 | 2 |
| 4014 | 3 |
| 6211 | 4 |
| 114 | 5 |
| 23 | 8 |
| 20 | 9 |
| 2836 | 10 |
| 150 | 11 |
| 439 | 12 |
| 15 | 13 |
| 975 | 14 |
| 7 | 15 |
| 625 | 100 |
| 19 | 101 |
| 149 | 828 |
| 30 | 829 |
| 49 | 1728 |
+----------+----------------+
19 rows
(nlwiki)> SELECT COUNT(*), page_namespace FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND (rc_source = 'mw.edit' OR rc_source = 'mw.new') 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 |
+----------+----------------+
| 2619 | 0 | Main 1% gap
| 293 | 1 | Talk 12% gap
| 103 | 2 | User 1% gap
| 48 | 3 | User talk 1% gap
| 41 | 4 | Project 0.6% gap
| 6 | 5 |
| 2 | 8 |
| 109 | 10 | Template 4% gap
| 4 | 12 |
| 74 | 14 | Category 8% gap
| 4 | 15 |
| 1 | 100 |
| 1 | 829 |
| 1 | 1728 |
+----------+----------------+
14 rows
(enwiktionary)> SELECT COUNT(*), page_namespace FROM revision LEFT JOIN recentchanges ON rev_id = rc_this_oldid AND (rc_source = 'mw.edit' OR rc_source = 'mw.new') LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' GROUP BY page_namespace;
+----------+----------------+
| COUNT(*) | page_namespace |
+----------+----------------+
| 576186 | 0 |
| 1299 | 1 |
| 4558 | 2 |
| 1524 | 3 |
| 5426 | 4 |
| 88 | 5 |
| 46 | 8 |
| 28 | 9 |
| 16100 | 10 |
| 165 | 11 |
| 3 | 12 |
| 18887 | 14 |
| 34 | 15 |
| 1690 | 100 |
| 36 | 101 |
| 505 | 106 |
| 3 | 108 |
| 524 | 110 |
| 1 | 111 |
| 579 | 114 |
| 6701 | 118 |
| 95 | 119 |
| 4956 | 828 |
| 115 | 829 |
+----------+----------------+
24 rows in set (6.077 sec)
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' OR rc_source = 'mw.new') LEFT JOIN page ON page_id = rev_page WHERE rev_timestamp LIKE '202512%' AND rc_id IS NULL GROUP BY page_namespace;