Sandbox - Quarry

SQL

SELECT page.page_title, actor_revision.actor_name, rev.rev_timestamp
FROM revision_userindex AS rev
JOIN page ON rev.rev_page = page.page_id
JOIN actor_revision ON actor_revision.actor_id = rev.rev_actor
WHERE actor_revision.actor_name = 'Ad Orientem' AND page.page_namespace = 4 AND page.page_title LIKE 'Articles_for_deletion/%' AND NOT page.page_title LIKE 'Articles_for_deletion/Log/%'
AND rev.rev_parent_id=0
ORDER BY rev.rev_timestamp DESC;

AخA
 
SELECT page.page_title, actor_revision.actor_name, rev.rev_timestampFROM revision_userindex AS revJOIN page ON rev.rev_page = page.page_idJOIN actor_revision ON actor_revision.actor_id = rev.rev_actorWHERE actor_revision.actor_name = 'Ad Orientem' AND page.page_namespace = 4 AND page.page_title LIKE 'Articles_for_deletion/%' AND NOT page.page_title LIKE 'Articles_for_deletion/Log/%'AND rev.rev_parent_id=0ORDER BY rev.rev_timestamp DESC;

SQL

Checking query status...