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 > 20210700000000 ORDER BY user_registration;
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...