user with twinkleoptions.js

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT('# [[Special:Contributions/', user_name, ']]') AS uname, CONCAT(' : [[:File:', REPLACE(page_title,'_',' '), ']]') AS fname
FROM commonswiki_p.user
INNER JOIN revision
ON rev_user = user_id
INNER JOIN page
ON page_id = rev_page
AND page_namespace = 6
AND page_is_redirect = 0
WHERE user_registration LIKE '201609%'
AND rev_timestamp > user_registration
AND rev_timestamp < user_registration + 3000000 #4 days
AND user_editcount = 1
AND LENGTH(user_name) > 6
AND user_name NOT LIKE '% %'
AND user_name NOT REGEXP '[0-9]$'
AND NOT EXISTS (SELECT 1 FROM page
                WHERE page_title = user_name
                AND page_namespace = 2)
AND EXISTS (SELECT 1 FROM externallinks
            WHERE el_from = page_id)
LIMIT 100;
SQL

Checking query status...
