SQL
AخA
SELECT
p.page_title,
(SELECT a.actor_name
FROM revision_userindex r2
JOIN actor_revision a ON r2.rev_actor = a.actor_id
WHERE r2.rev_page = p.page_id
ORDER BY r2.rev_timestamp ASC
LIMIT 1) AS first_editor
FROM revision_userindex r
JOIN page p ON r.rev_page = p.page_id
JOIN actor_revision ar ON ar.actor_id = r.rev_actor
WHERE ar.actor_name = "Ahecht"
AND p.page_namespace = 4
AND p.page_title LIKE "Articles_for_deletion%%"
AND NOT p.page_title LIKE "Articles_for_deletion/Log/%%"
ORDER BY r.rev_timestamp DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.