Untitled query #58158

SQL

SELECT
  ipb_address,
  ipb_by_text,
  ipb_timestamp,
  ipb_reason,
  ipb_auto,
  ipb_anon_only,
  ipb_create_account,
  ipb_user,
  ipb_allow_usertalk
FROM ipblocks
WHERE ipb_expiry = "infinity"
AND ipb_user = 0
AND ipb_address REGEXP '^[A-F\.0-9]+$'
AND ipb_reason NOT LIKE "%roxy%"
AND ipb_reason NOT LIKE "%roxie%"
AND ipb_reason NOT LIKE "%GWAblock%"
AND ipb_reason NOT LIKE "%host%"
AND ipb_reason NOT LIKE "%Host%"
AND ipb_reason NOT LIKE "%chool%"
AND ipb_reason NOT LIKE "%AOLblock%"
AND ipb_reason NOT LIKE "%nspeed%"
AND ipb_reason NOT LIKE "%dmin%"
AND ipb_reason NOT LIKE "%OTRS%"
AND ipb_reason NOT LIKE "%equest%"
AND ipb_reason NOT LIKE "%otrs%";
SQL

Checking query status...
