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

SQL

AخA
 
#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
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%')
#LIKE 'Print%' OR user_name LIKE '%print' OR user_name LIKE '%printer' OR user_name LIKE '%Akhileshpal%') AND  user_registration > 20210000000000
#LIKE '%Retzlaff%')
#REGEXP 'Alex ?Mtch' AND user_registration > 20210000000000)
#LIKE '%GT500' AND user_registration > 20200000000000)
#LIKE '%Abbydraw%' AND user_registration > 20200000000000)
#REGEXP '^[A-Z][a-z]+[A-Z][0-9][0-9]$' AND user_registration > 20220000000000)
#REGEXP 'IT[1Y]T' AND user_registration > 20210000000000)
#REGEXP '[Ss]angeeta' AND user_registration > 20220000000000)
LIKE 'Wikimz%' AND user_registration > 20220000000000)
#LIKE 'Parthempir%' OR user_name LIKE 'Parthmepir%' OR user_name LIKE 'Parthsidd%' OR user_name LIKE 'Cooldude%') AND user_registration > 20210600000000
#LIKE '%Esfwtomm%' 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.
All SQL code is licensed under CC0 License.

Checking query status...