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,'_',' '), ']] ([[m:Special:CentralAuth/', REPLACE (user_name,'_',' '), '|CA]]) ', # 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),' ', user_id) FROM .user #WHERE ((user_name LIKE '%TĂȘtu%') # OR (user_name LIKE '%tĂȘtu%') # OR (user_name LIKE '% nique %') # OR (user_name REGEXP 'Guillaume.+Kim') # OR (user_name REGEXP 'Jacquie et Michel') # OR (user_name LIKE '%Emmanuel Macron%') # ) AND user_registration > 20210707000000 #ORDER BY user_registration; SELECT 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 ,user_id FROM .user WHERE (user_name #IN ("Je suce des grosses bites juteuses", "Les chiottes qui puent la merde", "Votre cul est sale") #LIKE '%Fuzzing%'# AND user_registration > 20210000000000 #REGEXP '[Ff]orress?t' OR user_name REGEXP '[Zz]jho?[ol]lder' OR user_name LIKE '%29912%' #LIKE '%B_Sinha%' OR user_name LIKE '%Bikram%Sinha%' OR user_name LIKE '%BIKRAM%SINHA%' #REGEXP '^HN[0-9]{3}' AND user_registration > 20210700000000 #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 #LIKE 'Nabeel%' AND user_registration > 20210000000000 LIKE '%ohkenytp%' OR user_name LIKE 'Jermboy%') 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...