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

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.

Checking query status...