Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Achim55
.
Toggle Highlighting
SQL
SELECT CONCAT('* [[User:', 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 LIKE 'Bastian%' AND user_registration > 20220000000000) #(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 '%حسام علي%' AND user_registration > 20200000000000) #(user_name LIKE 'Debasis%' AND user_registration > 20200000000000) #(user_name LIKE '%von_Anhalt' AND user_registration > 20200000000000) #(user_name LIKE '%Nazari%' AND user_registration > 20211100000000) #(user_name LIKE '%حسام علي جاد%' AND user_registration > 20220000000000) #((user_name LIKE 'Bastian%' AND user_registration > 20220500000000) OR (user_name LIKE 'Bmmederos%' AND user_registration > 20200800000000) OR (user_name LIKE 'Mayra%' AND user_registration > 20220900000000)) AND user_name NOT REGEXP '[\ \.\-]' #((user_name LIKE 'Kongpc%' OR user_name LIKE 'KPC%') AND user_registration > 20210000000000) (user_name REGEXP '^M[ou]khtar.*Musheer' AND user_registration > 20210000000000) 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
.
Checking query status...