SELECT MIN(rev_timestamp) AS creation_date, REPLACE(page_title, 'Requests_for_adminship/', '') AS candidate_name

FROM page

LEFT JOIN revision ON page_id = rev_page

WHERE page_namespace = 4

AND page_title LIKE 'Requests_for_adminship/%'

AND page_title NOT LIKE 'Requests_for_adminship/20%'

AND page_title NOT LIKE 'Requests_for_adminship/Optional_RfA_candidate_poll%'

AND page_title NOT LIKE '%/Bureaucrat_chat'

AND page_title NOT IN('Requests_for_adminship/sandbox')

AND page_is_redirect = 0

GROUP BY page_title

ORDER BY rev_timestamp DESC

-- later, filter by successful requests. can probably check for a category or template