Candidate edit count at time of RFA

Fork of List of RFAs (including un-transcluded) by Novem Linguae

This query is marked as a draft This query has been published by Novem Linguae.

SQL

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

SQL

Checking query status...