FireflyBot G13 query

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...
