IP user pages on Commons

SQL

USE commonswiki_p;
SELECT CONCAT('{{noping|', user_name, '}}') AS username, log_timestamp FROM commonswiki_p.user
INNER JOIN logging ON log_user = user_id
WHERE log_timestamp >= '20160201'
AND log_timestamp <= '20160231'
AND user_name REGEXP '[0-9]{2}$'
AND log_type = 'newusers'
AND EXISTS (SELECT 1 FROM page
            WHERE page_namespace = 2
            AND page_title = user_name
            AND page_len < 100
            AND NOT EXISTS (SELECT 1 FROM categorylinks
                            WHERE cl_from = page_id
                            AND cl_to NOT LIKE 'Sockpuppet%')
           )
ORDER BY log_timestamp;
SQL

Checking query status...
