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.