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
Jack who built the house
.
Toggle Highlighting
SQL
use ruwiki_p; select user_name, concat(substring(user_registration, 1, 4), '-', substring(user_registration, 5, 2), '-', substring(user_registration, 7, 2), ' ', substring(user_registration, 9, 2), ':', substring(user_registration, 11, 2), ':', substring(user_registration, 13, 2)), concat('https://ru.wikipedia.org/wiki/Участник:', user_name) as "Ссылка" from user where not ( user_name regexp '[[:alpha:]]' or instr(user_name, 'а') or instr(user_name, 'б') or instr(user_name, 'в') or instr(user_name, 'г') or instr(user_name, 'д') or instr(user_name, 'е') or instr(user_name, 'ё') or instr(user_name, 'ж') or instr(user_name, 'з') or instr(user_name, 'и') or instr(user_name, 'й') or instr(user_name, 'к') or instr(user_name, 'л') or instr(user_name, 'м') or instr(user_name, 'н') or instr(user_name, 'о') or instr(user_name, 'п') or instr(user_name, 'р') or instr(user_name, 'с') or instr(user_name, 'т') or instr(user_name, 'у') or instr(user_name, 'ф') or instr(user_name, 'ъ') or instr(user_name, 'ц') or instr(user_name, 'ч') or instr(user_name, 'ш') or instr(user_name, 'щ') or instr(user_name, 'ъ') or instr(user_name, 'ы') or instr(user_name, 'ь') or instr(user_name, 'э') or instr(user_name, 'ю') or instr(user_name, 'я') or instr(user_name, 'А') or instr(user_name, 'Б') or instr(user_name, 'В') or instr(user_name, 'Г') or instr(user_name, 'Д') or instr(user_name, 'Е') or instr(user_name, 'ё') or instr(user_name, 'Ж') or instr(user_name, 'З') or instr(user_name, 'И') or instr(user_name, 'Й') or instr(user_name, 'К') or instr(user_name, 'Л') or instr(user_name, 'М') or instr(user_name, 'Н') or instr(user_name, 'О') or instr(user_name, 'П') or instr(user_name, 'Р') or instr(user_name, 'С') or instr(user_name, 'Т') or instr(user_name, 'У') or instr(user_name, 'Ф') or instr(user_name, 'Ъ') or instr(user_name, 'Ц') or instr(user_name, 'Ч') or instr(user_name, 'Ш') or instr(user_name, 'Щ') or instr(user_name, 'Ъ') or instr(user_name, 'Ы') or instr(user_name, 'Ь') or instr(user_name, 'Э') or instr(user_name, 'Ю') or instr(user_name, 'Я')) order by user_registration desc limit 10
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...