NPP Recruitment - Editors by experience >10k edits

SQL

SELECT page_title as AFD, actor_name as User,
    date_format(rev_timestamp,'%Y-%m-%dT-%H:%i+00') as `Revision Timestamp`
FROM page p
JOIN revision_userindex ON rev_page = page_id AND rev_parent_id = 0
JOIN actor_revision ON actor_id = rev_actor
JOIN user_groups ON ug_user = actor_user
WHERE page_title LIKE 'Articles_for_deletion/%'
AND page_namespace = 4
    AND (ug_group = 'patroller' OR ug_group = 'sysop')
    AND rev_timestamp > NOW() - INTERVAL 7 DAY
    AND EXISTS(
        SELECT 1 FROM pagetriage_page WHERE ptrp_page_id = (
            SELECT page_id FROM page
            WHERE page_namespace = 0
            AND page_title =
                REGEXP_REPLACE(SUBSTR(p.page_title, 23), "_?\\(\\d+[a-z]{2}_nomination\\)", "")
    )
)
ORDER BY rev_timestamp desc
SQL

Checking query status...
