Fork of
Shortest good articles
by Ahecht
This query is marked as a draft
This query has been published
by Ahecht.
SQL
AخA
SELECT page.page_title, first_actor.actor_name, MIN(rev.rev_timestamp) AS rev_timestamp
FROM
(SELECT rev_page, rev_actor, rev_timestamp
FROM revision_userindex
JOIN actor_revision ON actor_revision.actor_id = revision_userindex.rev_actor
WHERE actor_revision.actor_name = 'Maile66'
) AS rev
JOIN page ON rev.rev_page = page.page_id
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 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;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.