SQL
AخA
SELECT recent.page_title, first_actor.actor_name AS first_editor
FROM (
SELECT p.page_title, p.page_id
FROM revision_userindex AS rev
JOIN page AS p ON rev.rev_page = p.page_id
JOIN actor_revision AS actor ON actor.actor_id = rev.rev_actor
WHERE actor.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 rev.rev_timestamp DESC
LIMIT 200
) AS recent
JOIN revision_userindex AS first_rev ON first_rev.rev_page = recent.page_id AND first_rev.rev_parent_id = 0
JOIN actor_revision AS first_actor ON first_actor.actor_id = first_rev.rev_actor;
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.