Page MenuHomePhabricator
Paste P252

enwiki - pages in wrong namespace
ActivePublic

Authored by Mr.Z-man on Feb 2 2015, 3:21 PM.
Tags
None
Referenced Files
F34060: enwiki_-_pages_in_wrong_namespace
Feb 2 2015, 3:21 PM
Subscribers
Tokens
"Like" token, awarded by Anomie.
MariaDB [enwiki_p]> SELECT rev_id, page_id, page_title, rev_timestamp, rev_user_text FROM revision JOIN page ON page_id=rev_page WHERE page_namespace=0 AND (page_title LIKE 'Talk:%' OR page_title LIKE 'User:%' OR page_title LIKE 'User_talk:%' OR page_title LIKE 'Wikipedia:%' OR page_title LIKE 'Wikipedia:%' OR page_title LIKE 'Wikipedia_talk:%' OR page_title LIKE 'Wikipedia_talk:%' OR page_title LIKE 'TimedText:%' OR page_title LIKE 'TimedText_talk:%' OR page_title LIKE 'MediaWiki:%' OR page_title LIKE 'MediaWiki_talk:%' OR page_title LIKE 'Template:%' OR page_title LIKE 'Template_talk:%' OR page_title LIKE 'Help:%' OR page_title LIKE 'Help_talk:%' OR page_title LIKE 'Category:%' OR page_title LIKE 'Category_talk:%' OR page_title LIKE 'Media:%' OR page_title LIKE 'Portal:%' OR page_title LIKE 'Portal_talk:%' OR page_title LIKE 'Topic:%' OR page_title LIKE 'File_talk:%' OR page_title LIKE 'Book:%' OR page_title LIKE 'Book_talk:%' OR page_title LIKE 'Special:%' OR page_title LIKE 'Draft:%' OR page_title LIKE 'Draft_talk:%' OR page_title LIKE 'File:%' OR page_title LIKE 'Module:%' OR page_title LIKE 'Module_talk:%' OR page_title LIKE 'Education_Program:%' OR page_title LIKE 'Education_Program_talk:%' OR page_title LIKE 'WP:%' OR page_title LIKE 'WT:%' OR page_title LIKE 'Image_talk:%' OR page_title LIKE 'Image:%') ORDER BY rev_timestamp ASC;
+-----------+----------+-------------------------------------------------------------------------------------------+----------------+------------------+
| rev_id | page_id | page_title | rev_timestamp | rev_user_text |
+-----------+----------+-------------------------------------------------------------------------------------------+----------------+------------------+
| 644373915 | 45227105 | User:Cyberpower678/Tally | 20150127081559 | Cyberbot I |
| 644373973 | 45227111 | Wikipedia:Articles_for_deletion/Wo_sukuu_kai | 20150127081645 | Legobot |
| 644373997 | 45227114 | Wikipedia:Articles_for_deletion/Zen_Do_Kai_(3rd_nomination) | 20150127081702 | Legobot |
| 644374005 | 45227115 | Wikipedia:Articles_for_deletion/Óscar_Tejeda | 20150127081707 | Legobot |
| 644374095 | 45227117 | Template:Cratstats | 20150127081832 | Cyberbot I |
| 644374141 | 45227121 | User:TParis/RfX_Report | 20150127081904 | Cyberbot I |
| 644374145 | 45227123 | User:Cyberbot_II/Status | 20150127081909 | Cyberbot I |
| 644374151 | 45227124 | User:Cyberbot_Trial_Bot/Status | 20150127081911 | Cyberbot I |
| 644374188 | 45227128 | User:Cyberbot_I/Status | 20150127081941 | Cyberbot I |
| 644374223 | 45227130 | Template:RfA_tally | 20150127082007 | Cyberbot I |
| 644374752 | 45227163 | User:X!/RfX_Report | 20150127082753 | Cyberbot I |
| 644374842 | 45227168 | Book_talk:Lost_(TV_series_guide) | 20150127082902 | Cyberbot I |
| 644374880 | 45227171 | Wikipedia:Articles_for_deletion/Adland_(2nd_nomination) | 20150127082928 | Northamerica1000 |
| 644375225 | 45227195 | User:Cyberbot_I/adminrights-admins.js | 20150127083419 | Cyberbot I |
| 644375795 | 45227241 | User:GA_bot/Stats | 20150127084205 | Legobot |
| 644376457 | 45227281 | Book_talk:Math | 20150127085037 | Cyberbot I |
| 644377236 | 45227117 | Template:Cratstats | 20150127085833 | Cyberbot I |
| 644377240 | 45227117 | Template:Cratstats | 20150127085836 | Cyberbot I |
| 644377300 | 45227319 | Book_talk:Medical_Eponyms | 20150127085908 | Cyberbot I |
| 644377449 | 45227324 | Wikipedia:Requested_moves | 20150127090042 | RMCD bot |
| 644377627 | 45227336 | Wikipedia:Articles_for_deletion/Before_We_Say_Goodbye | 20150127090227 | Legobot |
| 644377685 | 45227342 | Wikipedia:Articles_for_deletion/Bryan_Garaventa | 20150127090309 | Legobot |
| 644377689 | 45227345 | Wikipedia:Articles_for_deletion/Busiest_airports_in_Florida_in_2013 | 20150127090312 | Legobot |
| 644377728 | 45227348 | Wikipedia:Articles_for_deletion/Chris_Bucknam | 20150127090341 | Legobot |
| 644377736 | 45227349 | Wikipedia:Articles_for_deletion/Clifford_Peel | 20150127090346 | Legobot |
| 644377752 | 45227350 | Wikipedia:Articles_for_deletion/Craig_Abaya | 20150127090355 | Legobot |
| 644377759 | 45227351 | Wikipedia:Articles_for_deletion/Craig_Bonner | 20150127090357 | Legobot |
| 644377762 | 45227352 | Wikipedia:Articles_for_deletion/Crazy_You | 20150127090359 | Legobot |
| 644377814 | 45227356 | Wikipedia:Articles_for_deletion/Dev_Sen | 20150127090435 | Legobot |
| 644377819 | 45227357 | Wikipedia:Articles_for_deletion/Devuan | 20150127090436 | Legobot |
| 644377888 | 45227362 | Wikipedia:Articles_for_deletion/Embassy_of_Colombia,_Guatemala_City | 20150127090526 | Legobot |
| 644377972 | 45227366 | Book_talk:Mercedes_Benz | 20150127090625 | Cyberbot I |
| 644378189 | 45227381 | Wikipedia:WikiProject_Anatomy/Article_alerts | 20150127090844 | AAlertBot |
| 644378188 | 45227380 | Book_talk:Metallica | 20150127090844 | Cyberbot I |
| 644378475 | 45227399 | Wikipedia:WikiProject_California/San_Francisco_Bay_Area_task_force/Article_alerts/Archive | 20150127091121 | AAlertBot |
| 644378650 | 45227407 | User:Cyberpower678/RfX_Report | 20150127091251 | Cyberbot I |
| 644378682 | 45227117 | Template:Cratstats | 20150127091310 | Cyberbot I |
| 644378690 | 45227412 | Wikipedia:WikiProject_Delaware/Article_alerts/Archive | 20150127091315 | AAlertBot |
| 644378746 | 45227417 | Book_talk:Military_Careers,_Pt_I | 20150127091341 | Cyberbot I |
| 644378802 | 45227420 | Wikipedia:WikiProject_Estonia/Article_alerts | 20150127091406 | AAlertBot |
| 644378911 | 45227117 | Template:Cratstats | 20150127091511 | Cyberbot I |
| 644379537 | 45227449 | Wikipedia:WikiProject_New_York_Yankees/Article_alerts | 20150127092031 | AAlertBot |
| 644379650 | 45227457 | Wikipedia:WikiProject_Pakistan/Article_alerts/Archive | 20150127092126 | AAlertBot |
| 644379880 | 45227468 | Wikipedia:WikiProject_Russia/Science_and_education_in_Russia_task_force/Article_alerts | 20150127092302 | AAlertBot |
| 644379939 | 45227469 | Wikipedia:WikiProject_Serbia/Article_alerts | 20150127092328 | AAlertBot |
| 644380794 | 45227501 | User:VeblenBot/C/Good_article_nominees | 20150127093048 | VeblenBot |
| 644380806 | 45227503 | User:VeblenBot/C/January_2015_peer_reviews | 20150127093058 | VeblenBot |
| 644381043 | 45227512 | User:ClueBot_III/Detailed_Indices/!Viva_Nueva! | 20150127093336 | ClueBot III |
| 644381142 | 45227515 | User:ClueBot_III/Detailed_Indices/User_talk:Jazzeur/archive4 | 20150127093451 | ClueBot III |
| 644381291 | 45227522 | User_talk:War_wizard90 | 20150127093639 | ClueBot III |
| 644381297 | 45227117 | Template:Cratstats | 20150127093644 | Cyberbot I |
| 644381440 | 45227117 | Template:Cratstats | 20150127093822 | Cyberbot I |
| 644381589 | 45227537 | User:ClueBot_III/Indices/Talk:Benito_Mussolini | 20150127093951 | ClueBot III |
| 644381594 | 45227538 | User:ClueBot_III/Master_Detailed_Indices/Talk:Benito_Mussolini | 20150127093954 | ClueBot III |
| 644381691 | 45227543 | User:ClueBot_III/Indices/Talk:United_States_Constitution | 20150127094042 | ClueBot III |
| 644381862 | 45227567 | User:ClueBot_III/Indices/Talk:Sokal_affair | 20150127094205 | ClueBot III |
| 644381865 | 45227568 | User:ClueBot_III/Master_Detailed_Indices/Talk:Sokal_affair | 20150127094206 | ClueBot III |
| 644382027 | 45227575 | User:ClueBot_III/Indices/Wikipedia_talk:WikiProject_Encyclopaedia_Britannica | 20150127094349 | ClueBot III |
| 644382276 | 45227591 | User:ClueBot_III/Detailed_Indices/Talk:HIV/AIDS/Archive_11 | 20150127094638 | ClueBot III |
| 644382439 | 45227606 | User:ClueBot_III/Master_Detailed_Indices/Talk:Aqua_regia | 20150127094816 | ClueBot III |
| 644382844 | 45227117 | Template:Cratstats | 20150127095327 | Cyberbot I |
| 644383436 | 45227647 | Book_talk:Neptunium | 20150127095926 | Cyberbot I |
| 644383463 | 45227650 | Book_talk:NERIST | 20150127095939 | Cyberbot I |
| 644383530 | 45227655 | Wikipedia:Dashboard/Help_noticeboards | 20150127100022 | Legobot |
| 644383545 | 45227656 | User:ClueBot_III/Indices/Talk:Pakistan-administered_Kashmir | 20150127100029 | ClueBot III |
| 644383553 | 45227657 | User:ClueBot_III/Master_Detailed_Indices/Talk:Pakistan-administered_Kashmir | 20150127100032 | ClueBot III |
| 644383588 | 45227659 | Wikipedia:Articles_for_deletion/Alan_Rosen | 20150127100057 | Legobot |
| 644383672 | 45227664 | Book_talk:Neuroscience:_A_Primer | 20150127100153 | Cyberbot I |
| 644383697 | 45227665 | Wikipedia:Articles_for_deletion/Barbadians_in_Brazil | 20150127100207 | Legobot |
| 644383857 | 45227678 | User_talk:108.69.192.159 | 20150127100424 | Charlesdrakew |
| 644383922 | 45227681 | Wikipedia:Articles_for_deletion/Elanor_Gardner | 20150127100521 | Legobot |
| 644384142 | 45227697 | Wikipedia:Articles_for_deletion/Kelexis_Davenport | 20150127100827 | Legobot |
| 644384155 | 45227701 | User:ClueBot_III/Indices/Talk:Mircea_Eliade | 20150127100838 | ClueBot III |
| 644384198 | 45227705 | Wikipedia:Articles_for_deletion/Les_Aiglons | 20150127100916 | Legobot |
| 644384231 | 45227706 | User:ClueBot_III/Indices/Talk:Caligula_(film) | 20150127100942 | ClueBot III |
| 644384234 | 45227707 | User:ClueBot_III/Master_Detailed_Indices/Talk:Caligula_(film) | 20150127100944 | ClueBot III |
| 644384348 | 45227716 | Wikipedia:Articles_for_deletion/Misty_Lown | 20150127101115 | Legobot |
| 644384404 | 45227718 | Wikipedia:Articles_for_deletion/Nevada_Film_Critics_Society | 20150127101201 | Legobot |
| 644384448 | 45227117 | Template:Cratstats | 20150127101233 | Cyberbot I |
| 644384537 | 45227722 | User:ClueBot_III/Indices/Talk:Antidepressant | 20150127101343 | ClueBot III |
| 644384577 | 45227725 | Wikipedia:Articles_for_deletion/RIMES_(company) | 20150127101417 | Legobot |
| 644384717 | 45227735 | Wikipedia:Articles_for_deletion/Sultana_Mahdokht | 20150127101554 | Legobot |
| 644384877 | 45227747 | Wikipedia:Articles_for_deletion/Yosi_Sergant | 20150127101822 | Legobot |
| 644385013 | 45227754 | User:ClueBot_III/Master_Detailed_Indices/Talk:Olbers'_paradox | 20150127102006 | ClueBot III |
| 644963253 | 45227575 | User:ClueBot_III/Indices/Wikipedia_talk:WikiProject_Encyclopaedia_Britannica | 20150131091613 | 77.218.253.63 |
| 645010876 | 45227575 | User:ClueBot_III/Indices/Wikipedia_talk:WikiProject_Encyclopaedia_Britannica | 20150131170206 | Cryptic |
| 645055570 | 45269032 | User_talk:Fatemi127 | 20150131222900 | Stefan2 |
| 645295671 | 45269032 | User_talk:Fatemi127 | 20150202120641 | GZWDer |
| 645295812 | 45269032 | User_talk:Fatemi127 | 20150202120814 | GZWDer |
+-----------+----------+-------------------------------------------------------------------------------------------+----------------+------------------+
89 rows in set (0.02 sec)

Event Timeline

Mr.Z-man changed the title of this paste from untitled to enwiki - pages in wrong namespace.
Mr.Z-man updated the paste's language from autodetect to text.
Mr.Z-man changed the visibility from "Public (No Login Required)" to "Mr.Z-man (Mr.Z-man)".
Mr.Z-man changed the visibility from "Mr.Z-man (Mr.Z-man)" to "Public (No Login Required)".