Fork of
Expiring G13 drafts
by Perryprog
This query is marked as a draft
This query has been published
by Firefly.
SQL
AخA
SELECT DISTINCT page_title, rev_timestamp as URL
FROM page
WHERE page_namespace = 118
AND page_is_redirect = 0
AND page_id NOT IN
(
SELECT rev_page
FROM revision_userindex
WHERE rev_timestamp > (NOW() - INTERVAL 5 MONTH)
AND rev_actor NOT IN
(
SELECT actor_id
FROM actor
INNER JOIN user_groups ON (ug_user = actor_user AND
ug_group = 'bot')
)
)
ORDER BY rev_timestamp;
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.