Drafts eligible for CSD G13

Fork of Drafts approaching CSD G13 eligibility by Firefly

This query is marked as a draft This query has been published by Firefly.

SQL

SELECT DISTINCT CONCAT("Draft:",page_title),
(select rev_timestamp from revision where rev_page=page_id order by rev_timestamp desc limit 1) as rev_timestamp_,
(select actor_name from actor where actor_id=(select rev_actor from revision where rev_page=page_id order by rev_timestamp asc limit 1)) as actor_name_
FROM page
WHERE page_namespace = 118
  AND page_is_redirect = 0
  AND (select rev_timestamp from revision where rev_page=page_id order by rev_timestamp desc limit 1) < (NOW() - INTERVAL 6 MONTH)

ORDER BY rev_timestamp_;

SQL

Checking query status...