Jump to content

User:Gmaxwell/nonalphausers

From Wikipedia, the free encyclopedia

1,000 randomly selected users whos accounts where created in the last year, whos names do not contain any of the letters of the english alphabet, and who have at one non-deleted edit.

select concat('*Special:Contributions/', user_name,'') from user where user_registration>'20051215000000' and user_name not regexp '[A-Za-z]' and exists (select 1 from revision where rev_user_text=user_name limit 1) order by rand() limit 1000;