Untitled query #23375

SQL

use enwiki_p;
SELECT user_name, user_editcount, user_registration, last_edit
FROM `user`

JOIN (select rev_user, max(rev_timestamp) as last_edit from revision_userindex where rev_user = user_id group by rev_user) latest_edit_cnt on user_id = latest_edit_cnt.rev_user
JOIN (select rev_user, count(*) as mainspace_edits from revision_userindex join page on rev_page = page_id where page_namespace = 0 and rev_timestamp < 20171101000000 and rev_user = user_id group by rev_user) mainspace_contrib_cnt on user_id = mainspace_contrib_cnt.rev_user
WHERE last_edit > 20161127000000
    AND user_registration < 20171028000000
    AND mainspace_edits > 149
;
SQL

Checking query status...
