IP user pages on Commons

SQL

USE commonswiki_p;
SELECT u.user_name, log_timestamp FROM commonswiki_p.user u
INNER JOIN logging ON log_user = u.user_id
WHERE log_timestamp >= '20160101'
AND log_timestamp <= '20160131'
AND u.user_name REGEXP '[0-9]{2}$'
AND log_type = 'newusers'
AND EXISTS (SELECT 1 FROM page
            WHERE page_namespace = 2
            AND page_title = u.user_name
            AND page_len < 100)
AND EXISTS (SELECT 1 FROM commonswiki_p.user u2
            INNER JOIN logging ON log_user = u2.user_id
            WHERE u2.user_id = u.user_id
            AND log_action = 'upload')
LIMIT 100;
SQL

Checking query status...
