AfD created by NPPs

SQL

SELECT page_title, actor_name, rev_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+(nd|rd|th)_nomination\\)", "")
    )
)
SQL

Checking query status...
