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 `AFD created on`

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

ORDER BY rev_timestamp desc;