Untitled query #86742

SQL

SELECT ipblocks_ipindex.ipb_address,
       ipblocks_ipindex.ipb_anon_only,
       ipblocks_ipindex.ipb_timestamp, 
       comment.comment_text AS ipb_reason, 
       actor.actor_name
FROM ipblocks_ipindex
JOIN actor ON ipblocks_ipindex.ipb_by_actor = actor.actor_id
JOIN comment ON ipblocks_ipindex.ipb_reason_id = comment.comment_id
WHERE ipblocks_ipindex.ipb_expiry = 'infinity'
  AND actor.actor_name != 'RonaldB'
  AND ipblocks_ipindex.ipb_user IS NULL
  AND NOT (ipblocks_ipindex.ipb_address LIKE '%/%' AND comment.comment_text RLIKE '(?i)(blockreason[0-9]|proxy)')
  AND NOT comment.comment_text rlike '(?i)(school|verzoek|aanvraag|kliksafe|overleg.gebruiker)'
ORDER BY ipblocks_ipindex.ipb_address ASC;
SQL

Checking query status...
