AfDs created by an NPP reviewer or administrator in the past week

SQL

select d, count(*) from (SELECT REGEXP_REPLACE(SUBSTR(p.page_title, 23), "_?\\(\\d+[a-z]{2}_nomination\\)", "") as Page, page_title as 'AFD link', actor_name as User,
    date_format(min(rev_timestamp),'%Y-%m-%d') as `d`
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 in ('patroller', '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\\)", "")
    )
)
group by page_title) x
group by d
order by d;
SQL

Checking query status...
