SELECT /*nomonly: DISTINCT page_title, actor.actor_name*/ /*not nomonly*/page_title, first_actor.actor_name/*not nomonly*/ FROM revision_userindex AS rev

JOIN page ON rev.rev_page = page_id

JOIN actor_revision AS actor ON actor.actor_id = rev.rev_actor

/*not nomonly*/JOIN revision_userindex AS first_rev ON first_rev.rev_page = page_id AND first_rev.rev_parent_id = 0

JOIN actor_revision AS first_actor ON first_actor.actor_id = first_rev.rev_actor/*not nomonly*/

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/%%"

/*nomonly: AND rev.rev_parent_id = 0*/

ORDER BY rev.rev_timestamp DESC;

LIMIT 200