WP0 blocked users without category (ipblocks, no materialization)

SQL

USE commonswiki_p;
SELECT NOW();

SET SESSION optimizer_switch='materialization=off';

SELECT ipb_address, ipb_reason, ipb_by_text
FROM ipblocks
WHERE ipb_reason REGEXP '[[:<:]](?:T129845|Z567|Z591|WP0|wikipedia (?:zero|0))[[:>:]]'
AND ipb_user != 0
AND NOT REPLACE(ipb_address, ' ', '_') IN (
  SELECT page_title
  FROM page
  INNER JOIN categorylinks
  ON cl_from = page_id
  WHERE cl_type = "page"
  AND page_namespace = 2
  AND cl_to IN (
    SELECT 'Users_suspected_of_abusing_Wikipedia_Zero' AS catname
    UNION
    SELECT page_title AS catname
    FROM page
    INNER JOIN categorylinks
    ON cl_from = page_id
    WHERE cl_type = 'subcat'
    AND cl_to = 'Users_suspected_of_abusing_Wikipedia_Zero'
  )
) /* EXPLAINs:
+------+--------------------+---------------+--------+---------------------------------------------------------------------+------------+---------+-----------------------------------+---------+-------------------------------------------------+
| id   | select_type        | table         | type   | possible_keys                                                       | key        | key_len | ref                               | rows    | Extra                                           |
+------+--------------------+---------------+--------+---------------------------------------------------------------------+------------+---------+-----------------------------------+---------+-------------------------------------------------+
|    1 | PRIMARY            | ipblocks      | ALL    | ipb_user                                                            | NULL       | NULL    | NULL                              |  107088 | Using where                                     |
|    2 | DEPENDENT SUBQUERY | page          | eq_ref | PRIMARY,name_title,page_random,page_len,page_redirect_namespace_len | name_title | 261     | const,func                        |       1 | Using where; Using index; Full scan on NULL key |
|    2 | DEPENDENT SUBQUERY | categorylinks | ref    | PRIMARY,cl_timestamp,cl_sortkey,cl_collation_ext                    | PRIMARY    | 4       | commonswiki.page.page_id          | 2698321 | Using where                                     |
|    3 | DEPENDENT SUBQUERY | NULL          | NULL   | NULL                                                                | NULL       | NULL    | NULL                              |    NULL | No tables used                                  |
|    4 | DEPENDENT UNION    | categorylinks | ref    | PRIMARY,cl_timestamp,cl_sortkey,cl_collation_ext                    | cl_sortkey | 258     | const,const                       |      22 | Using where; Using index                        |
|    4 | DEPENDENT UNION    | page          | eq_ref | PRIMARY,page_random,page_len,page_redirect_namespace_len            | PRIMARY    | 4       | commonswiki.categorylinks.cl_from |       1 | Using where                                     |
| NULL | UNION RESULT       | <union3,4>    | ALL    | NULL                                                                | NULL       | NULL    | NULL                              |    NULL |                                                 |
+------+--------------------+---------------+--------+---------------------------------------------------------------------+------------+---------+-----------------------------------+---------+-------------------------------------------------+
*/
;
SQL

Checking query status...
