Use nlwiki_p;

SELECT

  CONCAT('*[[Gebruiker:', user_name, ']]') as showname,

  user_name,

  ipb_address,

  ipb_by_text,

  ipb_timestamp,

  ipb_expiry,

  ipb_reason

FROM `user`

JOIN ipblocks

WHERE (user_name REGEXP '[Pp]orno'

      or user_name REGEXP '[Pp]oep'

      or user_name REGEXP '[Kk]ak'

      or user_name REGEXP '[Kk]anker'

      or user_name REGEXP '[Ll]ul'

      or user_name REGEXP '[Pp]ies'

      or user_name REGEXP '[Nn]euk'

      or user_name REGEXP '[Tt]ering'

      or user_name REGEXP '[Bb]itch'

      or user_name REGEXP '[Dd]rol'

      or user_name REGEXP '[Bb]asvb')

AND (NOT EXISTS user_name=ipb_address

     OR NOT (ipb_expiry = "infinity"

AND ipb_user != 0)

GROUP BY showname

Limit 500;

​