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 DISTINCT
page.page_title
FROM
(
SELECT
rev_page,
rev_actor,
rev_timestamp
FROM
revision_userindex
WHERE
rev_actor IN (
SELECT actor_id
FROM actor
WHERE actor_name = 'Maile66'
)
) AS filtered_revisions
JOIN page ON filtered_revisions.rev_page = page.page_id
JOIN actor ON actor.actor_id = filtered_revisions.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/%'
ORDER BY
filtered_revisions.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.