WP0 blocked users without category (ipblocks)

SQL

USE commonswiki_p;
SELECT NOW();

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 ipb_address IN (
  SELECT REPLACE(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 * FROM (
      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'
    ) wp0cats /* Using MATERIALIZED per https://stackoverflow.com/a/6157797 */
  )
) /* EXPLAINs:
+------+--------------+---------------+--------+---------------------------------------------------------------------+------------+---------+------------------------------------------+--------+--------------------------+
| id   | select_type  | table         | type   | possible_keys                                                       | key        | key_len | ref                                      | rows   | Extra                    |
+------+--------------+---------------+--------+---------------------------------------------------------------------+------------+---------+------------------------------------------+--------+--------------------------+
|    1 | PRIMARY      | ipblocks      | ALL    | ipb_user                                                            | NULL       | NULL    | NULL                                     | 106520 | Using where              |
|    2 | MATERIALIZED | page          | ref    | PRIMARY,name_title,page_random,page_len,page_redirect_namespace_len | name_title | 4       | const                                    |  84837 | Using index              |
|    2 | MATERIALIZED | <subquery3>   | ALL    | distinct_key                                                        | NULL       | NULL    | NULL                                     |     23 |                          |
|    2 | MATERIALIZED | categorylinks | eq_ref | PRIMARY,cl_timestamp,cl_sortkey,cl_collation_ext                    | PRIMARY    | 261     | commonswiki.page.page_id,wp0cats.catname |      1 | Using where              |
|    3 | MATERIALIZED | <derived4>    | ALL    | NULL                                                                | NULL       | NULL    | NULL                                     |     23 |                          |
|    4 | DERIVED      | NULL          | NULL   | NULL                                                                | NULL       | NULL    | NULL                                     |   NULL | No tables used           |
|    5 | UNION        | categorylinks | ref    | PRIMARY,cl_timestamp,cl_sortkey                                     | cl_sortkey | 258     | const,const                              |     22 | Using where; Using index |
|    5 | UNION        | page          | eq_ref | PRIMARY                                                             | PRIMARY    | 4       | commonswiki.categorylinks.cl_from        |      1 |                          |
| NULL | UNION RESULT | <union4,5>    | ALL    | NULL                                                                | NULL       | NULL    | NULL                                     |   NULL |                          |
+------+--------------+---------------+--------+---------------------------------------------------------------------+------------+---------+------------------------------------------+--------+--------------------------+
*/
;
SQL

Checking query status...
