Spam blocks - Quarry

SQL

SET
  STATEMENT max_statement_time = 60 FOR
SELECT
  DISTINCT actor_name,
  ipb_address,
  comment_text,
  ipb_timestamp
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 -- exclude IPs
  AND ipb_timestamp >= '20210101000000'
  AND (
    LOWER(comment_text) LIKE '%spam%'
    OR LOWER(comment_text) LIKE '%advert%'
    OR LOWER(comment_text) LIKE '%promo%'
  )
  AND LOWER(comment_text) NOT LIKE '%Promotional username%' -- exclude promotional username blocks
SQL

Checking query status...
