Untitled query #89952

SQL

SELECT /*nomonly:*/ DISTINCT page_title, actor.actor_name/**/ 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
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;

AخA
 
SELECT /*nomonly:*/ DISTINCT page_title, actor.actor_name/**/ FROM revision_userindex AS revJOIN page ON rev.rev_page = page_idJOIN actor_revision AS actor ON actor.actor_id = rev.rev_actorWHERE actor.actor_name = "Ahecht" AND page_namespace = 4AND 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;

SQL

Checking query status...