Offensive usernames by regex

Fork of Offensive usernames by regex by Cryptic

This query is marked as a draft This query has been published by Cryptic.

Usernames containing the string "nigger", with letters allowed to repeat any number of times; and whether and how long they're blocked.

For [[WP:AN#Can this be addressed?]] circa 11 July 2020.

SQL

SELECT user_name, ipb_expiry
FROM user
LEFT JOIN ipblocks ON ipb_user = user_id
WHERE user_name RLIKE '(?i)ni+gg+e+r';

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...