Untitled query #17334

SQL

use ruwiki_p;

select
	user_name as 'Имя',
    concat('https://ru.wikipedia.org/wiki/Участник:', user_name) as 'Ссылка',
	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)) as 'Дата регистрации',
    user_editcount as 'Число правок'
from user
where not (
    user_name regexp '[[:alpha:]]' or  # user_name regexp '^[[:alnum:][:print:]]+$' or
    user_name regexp '(а|б|в|г|д|е|ё|ж|з|и|й|к|л|м|н|о|п|р|с|т|у|ф|ъ|ц|ч|ш|щ|ъ|ы|ь|э|ю|я)'
  )
order by user_registration desc
SQL

Checking query status...
