Sandbox - Quarry

SQL

SELECT page.page_title, first_actor.actor_name, MIN(rev.rev_timestamp) AS 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
JOIN revision_userindex AS first_rev ON first_rev.rev_page = 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_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/%'
GROUP BY page.page_title, first_actor.actor_name
ORDER BY rev.rev_timestamp DESC;

AخA
 
SELECT page.page_title, first_actor.actor_name, MIN(rev.rev_timestamp) AS rev_timestampFROM revision_userindex AS revJOIN page ON rev.rev_page = page.page_idJOIN actor_revision ON actor_revision.actor_id = rev.rev_actorJOIN revision_userindex AS first_rev ON first_rev.rev_page = page.page_id AND first_rev.rev_parent_id = 0JOIN actor_revision AS first_actor ON first_actor.actor_id = first_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/%'GROUP BY page.page_title, first_actor.actor_nameORDER BY rev.rev_timestamp DESC;

SQL

Checking query status...