Acquisition comments

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 log_type = 'block'
      AND log_action = 'block'
      AND comment_text LIKE '%olocationwebhost-soft%'
  )
SELECT
  *
FROM
  ipblocks
  INNER JOIN blocked_ips ON blocked_ips.ip = ipblocks.ipb_address
WHERE
  TRUE
  AND ipb_user = 0
LIMIT 5;
SQL

Checking query status...
