SQL
AخA
SELECT p.page_title, first_editors.actor_name AS first_editor
FROM revision_userindex AS r
JOIN page ON r.rev_page = page.page_id
JOIN actor_revision ar ON ar.actor_id = r.rev_actor
JOIN (
SELECT r2.rev_page, a2.actor_name
FROM revision_userindex r2
JOIN actor_revision a2 ON r2.rev_actor = a2.actor_id
WHERE r2.rev_parent_id = 0 -- First edit where there's no previous revision
) first_editors ON first_editors.rev_page = page.page_id
WHERE ar.actor_name = "Ahecht"
AND page.page_namespace = 4
AND page.page_title LIKE "Articles_for_deletion%%"
AND NOT page.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.