SELECT /*nomonly:*/DISTINCT page_title, actor.actor_name, rev.rev_timestamp/**/ /*not nomonly:page_title, first_actor.actor_name, first_rev.rev_timestamp*/ 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*/

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;