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
Bri
.
Toggle Highlighting
SQL
Use enwiki_p; SELECT user_name FROM user WHERE user_registration >= 20180101000000 AND user_registration <= 20190731000000 AND editcount > 0 AND HOUR(user_registration) >= 3 and HOUR(user_registration) <= 4 AND length(user_name) >=8 AND length(user_name) <=12 AND ( user_name like ("Japa%") OR user_name like ("Cana%") OR user_name like ("Cypr%") OR user_name like ("Russ%") OR user_name like ("Pola%") OR user_name like ("Germ%") OR user_name like ("Alba%") OR user_name like ("Mold%") OR user_name like ("Pola%") OR user_name like ("Esto%") OR user_name like ("Jord%") OR user_name like ("Germ%") OR user_name like ("Chec%") OR user_name like ("Neth%") OR user_name like ("Belg%") OR user_name like ("Hung%") OR user_name like ("Croa%") OR user_name like ("Cana%") OR user_name like ("Guam%") OR user_name like ("Alba%") ) AND NOT user_name REGEXP "[0-9 \-\.]" ORDER BY user_name LIMIT 6500;
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...