List of RFAs (including un-transcluded)

SQL

SELECT MIN(rev_timestamp) AS creation_date, page_title
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 'Requests_for_adminship/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

SQL

Checking query status...