Recent changes from API-confirmed blocked proxies

SQL

SET
  STATEMENT max_statement_time = 120 FOR WITH blocked_ips AS (
    SELECT
      DISTINCT log_title AS ip
    FROM
      logging_userindex AS logging
      INNER JOIN actor_logging AS actor ON logging.log_actor = actor.actor_id
      INNER JOIN comment ON logging.log_comment_id = comment.comment_id
    WHERE
      TRUE
      AND actor_name = 'ST47ProxyBot'
      AND log_type = 'block'
      AND log_action = 'block'
      AND comment_text LIKE '%API-confirmed%'
  )
SELECT
  ip,
  rc_timestamp,
  rc_this_oldid,
  rc_namespace,
  rc_title
FROM
  recentchanges_userindex AS recentchanges
  INNER JOIN actor_recentchanges AS actor ON actor.actor_id = recentchanges.rc_actor
  INNER JOIN blocked_ips ON blocked_ips.ip = actor.actor_name
WHERE
  recentchanges.rc_type IN (0, 1)
ORDER BY
  rc_timestamp DESC
SQL

Checking query status...
