Untitled query #28429

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
and     page_is_redirect = 0
and		not exists (select 1 from templatelinks where tl_from = p.page_id and tl_namespace = 10 and tl_title = 'Promising_draft')
and		rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 6 MONTH),'%Y%m%d%H%i%S'))
union
select	concat('[[User:', page_title, ']]') Draft,
		case
        	when substring_index(page_title, '/', -1) in ('', 'sandbox', 'Sandbox') then ''
            else concat('[[', substring_index(page_title, '/', -1), ']]')
        end Article
from	templatelinks tl
		left join
		page p
        on tl.tl_from = p.page_id
		left join
        revision r
        on p.page_latest = r.rev_id
where	tl_from_namespace = 2
and		tl_namespace = 10
and		tl_title = 'AFC_submission'
and     page_is_redirect = 0
and		not exists (select 1 from templatelinks where tl_from = p.page_id and tl_namespace = 10 and tl_title = 'Promising_draft')
and		rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 6 MONTH),'%Y%m%d%H%i%S'))
;
SQL

Checking query status...
