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

SQL

AخA
 
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 '%حسام علي%') OR (user_name LIKE '%حسام جاد%')) AND user_registration > 20230428000000) #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 > 20230213000000 AND user_name NOT REGEXP '[\ \.\-]'
#(user_registration > 20230510000000 AND LENGTH(user_name) = 7 AND user_name REGEXP ' [A-Z][A-Z]$') #Bastian
#(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)
#(((user_name LIKE 'YeadHosen%') OR (user_name LIKE 'Yeadhosen%')) AND user_registration > 20220000000000)
#(user_name LIKE '%Mulkliff%' AND user_registration > 20230000000000)
#(user_name REGEXP '^Mihai[A-Z]' AND user_registration > 20230617000000)
#(user_name REGEXP '[Aa]ss?egaf' AND user_registration > 20230700000000)
#(user_name REGEXP 'Dorian ?Nuhiu' AND user_registration > 20230900000000)
#((user_name LIKE '%Katarighe%' OR user_name LIKE '%Kestilinna%') AND user_registration > 20230000000000)
#(user_name LIKE '%Rattanaja%' AND user_registration > 20200000000000)
#((user_name LIKE '%Miley%' AND (user_name LIKE '%Cyrus%' OR user_name LIKE '%Kylie%') OR user_name LIKE 'PsychoSquad%') AND user_registration > 20230900000000)
#((user_name REGEXP '[Aa]lif' OR user_name REGEXP '[Aa]nak') AND user_name REGEXP '[Ss]amad' AND user_registration > 20210000000000)
(user_name REGEXP 'Alzowin[iy]' AND user_registration > 20200000000000)
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.
All SQL code is licensed under CC0 License.

Query status: superseded