Recent changes from API-confirmed blocked proxies

SQL

SET
  STATEMENT max_statement_time = 60 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 * 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
ORDER BY rc_timestamp DESC

SQL

Checking query status...