Untitled query #86058

SQL

select concat('Draft:', page_title),   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 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 page where page_namespace = 4 and page_title = concat('Miscellany_for_deletion/Draft:', p.page_title)) and  rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 153 DAY),'%Y%m%d%H%i%S')) union select concat('User:', page_title),   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 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_target_id=(SELECT lt_id FROM linktarget     WHERE lt_namespace = 10 AND lt_title = 'AFC_submission') and     page_is_redirect = 0 and   not exists (select 1 from page where page_namespace = 4 and page_title = concat('Miscellany_for_deletion/User:', p.page_title)) and  rev_timestamp < (DATE_FORMAT((NOW() - INTERVAL 153 DAY),'%Y%m%d%H%i%S')) order by rev_timestamp;")
SQL

Checking query status...
