Ranges /16 per number of open proxy blocks

SQL

SET STATEMENT max_statement_time = 60 FOR
WITH proxy_blocks AS (
SELECT
  ip16,
  c
FROM
  (
    SELECT
      CONCAT(ip16, '.0.0/16') as ip16,
      count(*) AS c
    FROM
      (
        SELECT
          DISTINCT ipb_address,
        REGEXP_REPLACE(ipb_address, '\.[0-9]+\.[0-9]+(/[0-9]+)?$', '') AS ip16
        FROM
          ipblocks
          INNER JOIN comment ON (ipblocks.ipb_reason_id = comment.comment_id)
        WHERE
          TRUE
          AND ipb_user = 0
          AND ipb_address NOT LIKE '%:%' -- exclude IPv6
          AND ipb_address LIKE '%/%' -- only ranges
          AND ipb_address NOT LIKE '%/16'
          AND (
            FALSE
            OR comment_text LIKE '%roxy%'
            OR comment_text LIKE '%roxies%'
            OR comment_text LIKE '%NOP%'
            OR comment_text LIKE '%VPN%'
            OR comment_text LIKE '%colo%'
            OR comment_text LIKE '%webhost%'
          )
      ) AS q1
    GROUP BY
      ip16
  ) AS q2
WHERE
  TRUE
  AND c >= 2
)
SELECT * FROM proxy_blocks
ORDER BY c DESC, ip16 ASC
SQL

Checking query status...
