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%";