Last active
January 2, 2016 10:59
-
-
Save FunPika/8293444 to your computer and use it in GitHub Desktop.
External and interwiki links pointing to the old URL to the account creation tool.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
MariaDB [enwiki_p]> SELECT page_namespace, page_title FROM `externallinks` JOIN `page` ON page_id = el_from WHERE (el_to LIKE 'http://toolserver.org/~acc%' OR el_to LIKE 'https://toolserver.org/~acc%') AND page_namespace > 3 ORDER BY page_namespace; | |
+----------------+-------------------------------------------------------------------------+ | |
| page_namespace | page_title | | |
+----------------+-------------------------------------------------------------------------+ | |
| 4 | Village_pump_(proposals)/Archive_84 | | |
| 4 | Request_an_account/Guide | | |
| 4 | Village_pump_(policy)/Archive_77 | | |
| 4 | Village_pump_(policy)/Archive_77 | | |
| 4 | Village_pump_(proposals)/Archive_105 | | |
| 4 | Village_pump_(proposals)/Account_security | | |
| 4 | Administrators'_noticeboard/Archive215 | | |
| 4 | Village_pump_(miscellaneous)/Archive_41 | | |
| 4 | Request_an_account/Administrators | | |
| 4 | Request_an_account/Administrators | | |
| 4 | Help_desk/Archives/2010_February_8 | | |
| 4 | Account_creator | | |
| 4 | Village_pump_(miscellaneous)/Archive_43 | | |
| 4 | Village_pump_(miscellaneous)/Archive_44 | | |
| 4 | Village_pump_(proposals)/Archive_69 | | |
| 4 | Administrators'_noticeboard/2008_IWF_action | | |
| 4 | Bureaucrats'_noticeboard/Archive_24 | | |
| 4 | Village_pump_(proposals)/Archive_70 | | |
| 4 | Help_desk/Archives/2010_February_8 | | |
| 4 | Village_pump_(technical)/Archive_110 | | |
| 4 | Arbitration_Committee/CheckUser_and_Oversight/2013_CUOS_appointments | | |
| 4 | Village_pump_(proposals)/Archive_84 | | |
| 4 | Village_pump_(technical)/Archive_110 | | |
| 4 | Village_pump_(technical)/Archive_110 | | |
| 4 | Arbitration_Committee/CheckUser_and_Oversight/2013_CUOS_appointments/CU | | |
| 4 | Village_pump_(policy)/Archive_93 | | |
| 4 | Request_an_account/Guide | | |
| 4 | Request_an_account/Changelog | | |
| 4 | Administrators'_noticeboard/Archive250 | | |
| 4 | Village_pump_(proposals)/Archive_65 | | |
| 4 | Requests_for_adminship/Jeff_G. | | |
| 4 | Administrators'_noticeboard/Archive252 | | |
| 4 | Miscellany_for_deletion/Wikipedia:Request_an_account/Administrators | | |
| 4 | Miscellany_for_deletion/Wikipedia:ACC_tool_users'_pledge | | |
| 4 | WikiProject_user_warnings/old_details | | |
| 4 | Requests_for_adminship/Mlpearc | | |
| 4 | Administrators'_noticeboard/Archive242 | | |
| 4 | Userboxes/Wikipedia/User_groups | | |
| 4 | Bot_owners'_noticeboard/Archive_5 | | |
| 4 | Online_Ambassadors/Apply/Riley_Huntley | | |
| 4 | Administrators'_noticeboard/Archive242 | | |
| 4 | Bots/Requests_for_approval/WelcomerBot | | |
| 4 | Template_messages/User_talk_namespace/Blocks | | |
| 4 | Administrators'_noticeboard/Archive253 | | |
| 4 | Why_create_an_account? | | |
| 4 | Help_desk/Archives/2010_May_1 | | |
| 4 | Administrators'_noticeboard/IncidentArchive587 | | |
| 4 | Sockpuppet_investigations | | |
| 4 | Help_desk/Archives/2010_January_19 | | |
| 4 | Administrators'_noticeboard/Incidents/Soft_blocking_AOL | | |
| 4 | Request_an_account/Changelog | | |
| 4 | Request_an_account/Guide | | |
| 4 | Help_desk/Archives/2010_February_8 | | |
| 4 | Help_desk/Archives/2010_April_20 | | |
| 4 | Changing_username/Usurpations/Rejected/12 | | |
| 4 | Abuse_response/206.131.49.254 | | |
| 5 | Account_creator | | |
| 5 | Username_policy/Archive_17 | | |
| 5 | Help_desk/Archive_10 | | |
| 5 | Teahouse | | |
| 5 | Requests_for_permissions/Archive_4 | | |
| 5 | Teahouse/Archive_6 | | |
| 5 | Request_an_account | | |
| 5 | Account_creator | | |
| 5 | Request_an_account/Archive_4 | | |
| 5 | Request_an_account/Guide/Archive_1 | | |
| 5 | File_mover/proposal | | |
| 5 | Request_an_account/Guide/Archive_1 | | |
| 5 | Sockpuppet_investigations/Archives/Archive10 | | |
| 5 | Request_an_account/Guide/Archive_1 | | |
| 5 | Request_an_account/Guide/Archive_1 | | |
| 5 | Arbitration_Committee/Archive_16 | | |
| 5 | Request_an_account/Guide/Archive_1 | | |
| 5 | Request_an_account/Procedures | | |
| 5 | Sockpuppet_investigations/Archives/Archive9 | | |
| 5 | New_contributors'_help_page | | |
| 5 | Sockpuppet_investigations/Archives/Archive9 | | |
| 5 | Help_desk | | |
| 5 | Usernames_for_administrator_attention | | |
| 5 | Why_create_an_account? | | |
| 5 | Abuse_response/206.131.49.254 | | |
| 5 | Request_an_account/Guide | | |
| 8 | Cantcreateaccount-text | | |
| 8 | Ipbreason-dropdown | | |
| 8 | Ipbreason-dropdown/Templates/anonblock | | |
| 9 | Titleblacklist/Archive_2 | | |
| 10 | Colocationwebhost | | |
| 10 | Googleappspotblock | | |
| 10 | ACC-backlog | | |
| 10 | ACC-access | | |
| 10 | Acc | | |
| 10 | Acc/doc | | |
| 10 | UKBlock | | |
| 10 | Uw-acc | | |
| 10 | User_acct | | |
| 10 | User_wikipedia/acctoolserveruser | | |
| 10 | User_wikipedia/accountcreator | | |
| 10 | Anonblock | | |
| 10 | Editnotices/Page/Wikipedia:Requests_for_permissions/Account_creator | | |
| 10 | ACC-backlog | | |
| 10 | Checkuserblock-Alto | | |
| 10 | Account_creator_declined | | |
| 10 | Uw-acc | | |
| 10 | Checkuserblock-Synetrix | | |
| 11 | Googleappspotblock | | |
| 11 | Anonblock | | |
| 12 | I_have_been_blocked | | |
+----------------+-------------------------------------------------------------------------+ | |
107 rows in set (0.14 sec) | |
MariaDB [enwiki_p]> SELECT page_namespace, page_title FROM `iwlinks` JOIN `page` ON page_id = iwl_from WHERE iwl_prefix = 'tools' AND iwl_title LIKE '~acc%' AND page_namespace > 3 ORDER BY page_namespace; | |
+----------------+--------------------------------------------------------------------------------------------------------+ | |
| page_namespace | page_title | | |
+----------------+--------------------------------------------------------------------------------------------------------+ | |
| 4 | April_Fools/April_Fools'_Day_2011/My76StratRFA | | |
| 4 | Miscellany_for_deletion/User:Ironholds | | |
| 4 | Pending_changes/Request_for_Comment_February_2011/Archive_3 | | |
| 4 | Requests_for_adminship/HJ_Mitchell_3 | | |
| 4 | Requests_for_adminship/Logan | | |
| 4 | Articles_for_deletion/Log/2011_August_10 | | |
| 4 | Articles_for_deletion/SummerSlam_(2011) | | |
| 4 | Requests_for_adminship/Fluffernutter | | |
| 4 | Administrators'_noticeboard/Archive233 | | |
| 4 | Bureaucrats'_noticeboard/Archive_25 | | |
| 4 | Administrators'_noticeboard/Archive63 | | |
| 4 | Help_desk/Archives/2013_April_11 | | |
| 4 | WikiProject_user_warnings/old_details | | |
| 4 | MediaWiki_messages/Archive_4 | | |
| 4 | Abuse_reports/208.66.198.98 | | |
| 4 | Meetup/UK | | |
| 4 | Toolserver | | |
| 4 | Template_messages/User_talk_namespace/Blocks | | |
| 4 | Request_an_account/Guide | | |
| 4 | Editor_review/Guide | | |
| 4 | Huggle/Wine | | |
| 4 | Request_an_account/Guide | | |
| 4 | Help_desk/Archives/2009_May_8 | | |
| 4 | Request_an_account/Guide | | |
| 4 | Village_pump_(proposals)/Archive_65 | | |
| 4 | Request_an_account/Guide | | |
| 4 | Abuse_response/169.204.189.71 | | |
| 4 | Request_an_account/Changelog | | |
| 4 | Abuse_response/206.131.49.254 | | |
| 4 | Request_an_account/Changelog/r3334 | | |
| 4 | Request_an_account/Procedures | | |
| 4 | Deletion_review/Log/2011_March | | |
| 4 | Administrators'_noticeboard/Archive215 | | |
| 4 | Administrators'_noticeboard/Archive222 | | |
| 4 | Request_an_account/Guide | | |
| 4 | Deletion_review/Log/2011_March_16 | | |
| 4 | Miscellany_for_deletion/Wikipedia:Credo_accounts | | |
| 4 | Miscellany_for_deletion/Wikipedia:Administrators'_noticeboard | | |
| 5 | Abuse_response/169.204.189.71 | | |
| 5 | Request_an_account/Archive_5 | | |
| 5 | WikiProject_United_States_Public_Policy/Courses/Spring_2011/Seminar_in_Public_Affairs_(Byron_E._Price) | | |
| 5 | Abuse_response/206.131.49.254 | | |
| 8 | Ipbreason-dropdown | | |
| 8 | Ipbreason-dropdown/Templates/schoolblock | | |
| 8 | Ipbreason-dropdown | | |
| 10 | School_block/sandbox | | |
| 10 | School_block | | |
| 10 | CheckUser_block | | |
| 10 | Rangeblocked | | |
| 10 | Account_creator_declined | | |
+----------------+--------------------------------------------------------------------------------------------------------+ | |
50 rows in set (0.60 sec) | |
MariaDB [enwiki_p]> SELECT ipb_address FROM `ipblocks` WHERE ipb_reason LIKE '%toolserver.org/~acc%'; | |
+-----------------+ | |
| ipb_address | | |
+-----------------+ | |
| 198.38.10.1 | | |
| 80.239.242.0/23 | | |
| 23.241.74.200 | | |
+-----------------+ | |
3 rows in set (0.86 sec) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment