Untitled query #89952

SQL

SELECT page_title, first_actor.actor_name AS first_editor
FROM revision_userindex AS rev
JOIN page ON rev.rev_page = page_id
JOIN actor_revision ON actor_id = rev.rev_actor
JOIN revision_userindex AS first 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_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.rev_timestamp DESC;

AخA
 
SELECT page_title, first_actor.actor_name AS first_editorFROM revision_userindex AS revJOIN page ON rev.rev_page = page_idJOIN actor_revision ON actor_id = rev.rev_actorJOIN revision_userindex AS first ON first.rev_page = page_id AND first.rev_parent_id = 0JOIN actor_revision AS first_actor ON first_actor.actor_id = first.rev_actorWHERE actor_name = "Ahecht"AND page_namespace = 4AND page_title LIKE "Articles_for_deletion%%"AND NOT page_title LIKE "Articles_for_deletion/Log/%%"ORDER BY rev.rev_timestamp DESC;

SQL

Checking query status...