sock name patterns

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

SELECT CONCAT('* [[m:Special:CentralAuth/', REPLACE (user_name,'_',' '), ']]'), CONCAT(SUBSTR(user_registration,1,4),'-',SUBSTR(user_registration,5,2),'-',SUBSTR(user_registration,7,2),' ',SUBSTR(user_registration,9,2),':',SUBSTR(user_registration,11,2),':',SUBSTR(user_registration,13,2)) AS d
FROM .user WHERE
#(user_name IN ("Je suce des grosses bites juteuses", "Les chiottes qui puent la merde", "Votre cul est sale")
#(user_name LIKE '%Fuzzing%'# AND user_registration > 20210000000000
#(user_name REGEXP '[Ff]orress?t' OR user_name REGEXP '[Zz]jho?[ol]lder' OR user_name LIKE '%29912%'
#(user_name LIKE '%B_Sinha%' OR user_name LIKE '%Bikram%Sinha%' OR user_name LIKE '%BIKRAM%SINHA%'
#(user_name REGEXP '^HN[0-9]{3}' AND user_registration > 20210700000000
#(user_name REGEXP '([Ss]ister location|x fox [Ss]plits|nights at [Ff]reddy.s|[Ss]cott.*game|[Ss]cott [Cc]awthon)' OR user_name LIKE 'Igoryu%' OR user_name LIKE 'Iggory%' OR user_name LIKE 'Funtime 7%') AND user_registration > 20210600000000
#(user_name LIKE 'Nabeel%' AND user_registration > 20210000000000
#(user_name LIKE '%ohkenytp%' OR user_name LIKE 'Jermboy%')
#(user_name LIKE 'Print%' OR user_name LIKE '%print' OR user_name LIKE '%printer' OR user_name LIKE '%Akhileshpal%') AND  user_registration > 20210000000000
#(user_name LIKE '%Retzlaff%')
#(user_name REGEXP 'Alex ?Mtch' AND user_registration > 20210000000000)
#(user_name LIKE '%GT500' AND user_registration > 20200000000000)
#(user_name LIKE '%Abbydraw%' AND user_registration > 20200000000000)
#(user_name REGEXP '^[A-Z][a-z]+[A-Z][0-9][0-9]$' AND user_registration > 20220000000000)
#(user_name REGEXP 'IT[1Y]T' AND user_registration > 20210000000000)
#(user_name REGEXP '[Ss]angeeta' AND user_registration > 20220000000000)
#(user_name LIKE 'Wikimz%' AND user_registration > 20220000000000)
#(user_name LIKE 'Parthempir%' OR user_name LIKE 'Parthmepir%' OR user_name LIKE 'Parthsidd%' OR user_name LIKE 'Cooldude%') AND user_registration > 20210600000000
#(user_name LIKE '%Esfwtomm%' AND user_registration > 20210000000000)
#(user_name LIKE 'Laxmi%' AND user_registration > 20220000000000)
#(user_name REGEXP '2,?005$' AND user_registration > 20220000000000)
#(user_name LIKE 'Farhadalikh%' AND user_registration > 20210000000000)
#(user_name REGEXP '[a-z]1230$' AND user_registration > 20210000000000)
#(user_name REGEXP '[Aa]ssibey' AND user_registration > 20190600000000)
#(user_name REGEXP '[Bb]onsu$' AND user_registration > 20190600000000)
#(user_name LIKE 'Saeedgholi%' AND user_registration > 20130000000000)
#(user_name LIKE 'Debasis%' AND user_registration > 20200000000000)
#(user_name LIKE '%von_Anhalt' AND user_registration > 20200000000000)
#(((user_name LIKE '%Nazari%') OR (user_name LIKE '%جواد نظری%')) AND user_registration > 20211000000000) #Javad Nazari
#((user_name LIKE '%حسام علي جاد%') OR (user_name LIKE '%حسام علي%')) AND user_registration > 20220000000000) #Hossam Ali Gad
#((user_name LIKE 'Kongpc%' OR user_name LIKE 'KPC%') AND user_registration > 20210000000000)
#(user_name REGEXP '^M[ou]khtar.*Musheer' AND user_registration > 20210000000000)
#(user_name LIKE 'Zlibrary%' AND user_registration > 20220000000000)
((user_name LIKE 'Bastian%') OR (user_name LIKE 'Bamamedero%') OR (user_name LIKE 'Bmmederos%') OR (user_name LIKE 'Mayra%'))
 AND user_registration > 202302000000000 AND user_name NOT REGEXP '[\ \.\-]'
#(user_name REGEXP '^Vishal ?[Mm]eena' AND user_registration > 20200000000000)
#(user_name LIKE '%127' AND user_registration > 20220000000000)
#(((user_name LIKE '%Ghegadmal%') OR (user_name LIKE 'SBG%')) AND user_registration > 20180000000000)

ORDER BY user_id;
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...
