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