Ranges /24 per number of open proxy blocks

SQL

SET STATEMENT max_statement_time = 60 FOR
SELECT
  ip24,
  c
FROM
  (
    SELECT
      ip24,
      count(*) AS c
    FROM
      (
        SELECT
          DISTINCT ipb_address,
          REGEXP_REPLACE(ipb_address, '\.[0-9]+$', '') AS ip24
        FROM
          ipblocks -- INNER JOIN actor ON (ipblocks.ipb_by_actor = actor.actor_id)
          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 NOT LIKE '%/%' -- exclude ranges
          AND (
            comment_text LIKE '%roxy%'
            OR comment_text LIKE '%roxies%'
            OR comment_text LIKE '%NOP%'
            OR comment_text LIKE '%VPN%'
          )
      ) AS q1
    GROUP BY
      ip24
  ) AS q2
WHERE
  c >= 2
ORDER BY
  ip24 ASC
SQL

Checking query status...
