SQL
AخA
SELECT page_title, first_actor.actor_name AS first_editor
FROM revision_userindex
JOIN page ON rev_page = page_id
JOIN actor_revision AS actor ON actor.actor_id = rev_actor
JOIN revision_userindex AS first_rev ON first_rev_page = page_id AND first_rev_parent_id = 0
JOIN actor_revision AS first_actor ON first_actor.actor_id = first_rev_actor
WHERE actor.actor_name = "Ahecht"
AND page_namespace = 4
AND page_title LIKE "Articles_for_deletion%%"
AND NOT page_title LIKE "Articles_for_deletion/Log/%%"
ORDER BY 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.