acc_extlinks.txt

+----------------+--------------------------------------------------------------------------------------------------------+----------------+
| page_namespace | page_title                                                                                             | editprotect    |
+----------------+--------------------------------------------------------------------------------------------------------+----------------+
|              4 | Request_an_account/Changelog/r3334                                                                     | NULL           |
|              4 | Administrators'_noticeboard/Incidents/Soft_blocking_AOL                                                | NULL           |
|              4 | Request_an_account/Procedures                                                                          | NULL           |
|              4 | Changing_username/Usurpations/Rejected/12                                                              | NULL           |
|              4 | Request_an_account/Guide                                                                               | NULL           |
|              4 | Village_pump_(proposals)/Account_security                                                              | NULL           |
|              4 | Account_creator                                                                                        | NULL           |
|              4 | Online_Ambassadors/Apply/Riley_Huntley                                                                 | NULL           |
|              4 | Administrators'_noticeboard/2008_IWF_action                                                            | NULL           |
|              4 | Arbitration_Committee/CheckUser_and_Oversight/2013_CUOS_appointments                                   | NULL           |
|              4 | Arbitration_Committee/CheckUser_and_Oversight/2013_CUOS_appointments/CU                                | NULL           |
|              4 | Request_an_account/Administrators                                                                      | NULL           |
|              4 | Meetup/UK                                                                                              | NULL           |
|              4 | Bots/Requests_for_approval/WelcomerBot                                                                 | NULL           |
|              4 | Huggle/Wine                                                                                            | NULL           |
|              4 | Sockpuppet_investigations                                                                              | autoconfirmed  |
|              4 | April_Fools/April_Fools'_Day_2011/My76StratRFA                                                         | NULL           |
|              4 | WikiProject_user_warnings/old_details                                                                  | NULL           |
|              4 | Template_messages/User_talk_namespace/Blocks                                                           | NULL           |
|              4 | Request_an_account/Changelog                                                                           | NULL           |
|              4 | Toolserver                                                                                             | NULL           |
|              4 | Why_create_an_account?                                                                                 | autoconfirmed  |
|              4 | Userboxes/Wikipedia/User_groups                                                                        | NULL           |
|              4 | Editor_review/Guide                                                                                    | NULL           |
|              5 | Request_an_account/Guide                                                                               | NULL           |
|              5 | Teahouse                                                                                               | NULL           |
|              5 | Request_an_account                                                                                     | autoconfirmed  |
|              5 | Account_creator                                                                                        | NULL           |
|              5 | File_mover/proposal                                                                                    | NULL           |
|              5 | Request_an_account/Procedures                                                                          | NULL           |
|              5 | New_contributors'_help_page                                                                            | NULL           |
|              5 | Help_desk                                                                                              | NULL           |
|              5 | WikiProject_United_States_Public_Policy/Courses/Spring_2011/Seminar_in_Public_Affairs_(Byron_E._Price) | NULL           |
|              5 | Usernames_for_administrator_attention                                                                  | NULL           |
|              5 | Why_create_an_account?                                                                                 | NULL           |
|              8 | Ipbreason-dropdown/Templates/schoolblock                                                               | NULL           |
|              8 | Cantcreateaccount-text                                                                                 | NULL           |
|              8 | Ipbreason-dropdown                                                                                     | NULL           |
|              8 | Ipbreason-dropdown/Templates/anonblock                                                                 | NULL           |
|             10 | Checkuserblock-Alto                                                                                    | templateeditor |
|             10 | Account_creator_declined                                                                               | NULL           |
|             10 | Checkuserblock-Synetrix                                                                                | NULL           |
|             10 | Editnotices/Page/Wikipedia:Requests_for_permissions/Account_creator                                    | NULL           |
|             10 | UKBlock                                                                                                | autoconfirmed  |
|             10 | Colocationwebhost                                                                                      | templateeditor |
|             10 | Googleappspotblock                                                                                     | sysop          |
|             10 | School_block                                                                                           | sysop          |
|             10 | User_acct                                                                                              | NULL           |
|             10 | ACC-access                                                                                             | NULL           |
|             10 | Rangeblocked                                                                                           | sysop          |
|             10 | Anonblock                                                                                              | templateeditor |
|             10 | Acc                                                                                                    | NULL           |
|             10 | ACC-backlog                                                                                            | NULL           |
|             10 | Acc/doc                                                                                                | NULL           |
|             10 | Uw-acc                                                                                                 | autoconfirmed  |
|             10 | School_block/sandbox                                                                                   | NULL           |
|             10 | User_wikipedia/acctoolserveruser                                                                       | NULL           |
|             10 | CheckUser_block                                                                                        | templateeditor |
|             10 | User_wikipedia/accountcreator                                                                          | NULL           |
|             11 | Googleappspotblock                                                                                     | NULL           |
|             11 | Anonblock                                                                                              | NULL           |
|             12 | I_have_been_blocked                                                                                    | autoconfirmed  |
+----------------+--------------------------------------------------------------------------------------------------------+----------------+
62 rows in set (0.20 sec)

ipblocks.txt

+-----------------+
| ipb_address     |
+-----------------+
| 198.38.10.1     |
| 80.239.242.0/23 |
| 23.241.74.200   |
+-----------------+
3 rows in set (0.86 sec)

query.sql

SELECT
    pages.page_namespace,
    pages.page_title,
    restrictions.pr_level as editprotect
FROM
    (SELECT 
        page_id, 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
            AND page_title NOT LIKE '%Archive%' 
            AND page_title NOT LIKE '%adminship%'
            AND page_title NOT LIKE '%eletion%'
            AND page_title NOT LIKE '%Abuse%'
    UNION DISTINCT SELECT 
        page_id, 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
            AND page_title NOT LIKE '%Archive%'
            AND page_title NOT LIKE '%adminship%'
            AND page_title NOT LIKE '%eletion%'
            AND page_title NOT LIKE '%Abuse%'
    ORDER BY page_namespace) pages
        LEFT OUTER JOIN
    (SELECT 
        *
    FROM
        page_restrictions
    WHERE
        pr_type = 'edit') restrictions ON restrictions.pr_page = pages.page_id;

query2.sql

SELECT ipb_address FROM `ipblocks` WHERE ipb_reason LIKE '%toolserver.org/~acc%';