enwiki: G13 drafts

SQL

select	concat('[[Draft:', page_title, ']]') Draft, concat('[[', page_title, ']]') Article
from	page p
		left join
        revision r
        on p.page_latest = r.rev_id
where	(page_namespace = 118 or exists (select 1 from templatelinks where tl_from = p.page_id and tl_title = 'AFC_submission'))
and     page_is_redirect = 0
and		rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 6 MONTH),'%Y%m%d%H%i%S'))
and		not exists (select 1 from templatelinks where tl_from = p.page_id and tl_namespace = 10 and tl_title = 'Promising_draft')
SQL

Checking query status...
