There are pages on English Wikipedia where page.page_latest = 0 in the database. This causes pages such as https://en.wikipedia.org/wiki/User_talk:1r3gr37n0n that "exist", but have no revision content or history.
1 | mysql:wikiadmin@db1057 [enwiki]> select page_id, page_namespace, page_title, page_touched from page where page_latest=0; |
---|---|
2 | +----------+----------------+------------------------------------------------------------------------+----------------+ |
3 | | page_id | page_namespace | page_title | page_touched | |
4 | +----------+----------------+------------------------------------------------------------------------+----------------+ |
5 | | 19113987 | 3 | 1r3gr37n0n | 20150331171950 | |
6 | | 19399178 | 3 | Vd437 | 20080920135258 | |
7 | | 20513897 | 3 | Heelo1 | 20110929011904 | |
8 | | 22427194 | 3 | HOTPOCKETSG | 20090415233805 | |
9 | | 22427202 | 3 | Jaeh0317 | 20090415233921 | |
10 | | 24090446 | 3 | Mightym53821 | 20090824001330 | |
11 | | 33750317 | 3 | 68.148.238.76 | 20111114234018 | |
12 | | 35711061 | 3 | Lilyonthevalley | 20120503210559 | |
13 | | 36111672 | 4 | Articles_for_deletion/2009_Sulu_kidnapping_crisis | 20120611233958 | |
14 | | 36111674 | 4 | Articles_for_deletion/3_Libras_(song) | 20120611234018 | |
15 | | 36111680 | 3 | Ttylxox1000 | 20120611234127 | |
16 | | 36111682 | 4 | Articles_for_deletion/333:_A_Bibliography_of_the_Science-Fantasy_Novel | 20120611234142 | |
17 | | 36111687 | 4 | Articles_for_deletion/2009_Sulu_kidnapping_crisis_(2nd_nomination) | 20120611234238 | |
18 | | 36111692 | 4 | Articles_for_deletion/2009_Sulu_kidnapping_crisis_(3rd_nomination) | 20120611234312 | |
19 | | 36111727 | 3 | Vishal.gkamath | 20120611235022 | |
20 | | 41990041 | 3 | 71.129.57.41 | 20140219173942 | |
21 | +----------+----------------+------------------------------------------------------------------------+----------------+ |
22 | 16 rows in set (24.66 sec) |
Womp womp.