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.rev_page, rev.rev_actor, rev.rev_timestamp FROM revision_userindex AS rev
WHERE rev.rev_actor IN
(SELECT actor_id FROM actor_revision WHERE actor_name = 'Maile66')
) 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
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.