FA WP AfDs not properly archived

SQL

use fawiki_p;

select concatenate('ویکی‌پدیا:', page_title)
from page
left join
(
  select tl_title
  from templatelinks
  join page
  on tl_from = page_id
  where tl_namespace = 4
  and page_title = 'نظرخواهی_برای_حذف'
  and page_namespace = 4
) C
on C.tl_title = page_title
left join
(
  select pl_title
  from pagelinks
  join page
  on pl_from = page_id
  where pl_namespace = 4
  and page_title like 'نظرخواهی_برای_حذف/بایگانی%'
  and page_namespace = 4
) A
on A.pl_title = page_title
where page_title like 'نظرخواهی_برای_حذف/%'
and page_title not like 'نظرخواهی_برای_حذف/بایگانی/%'
and page_namespace = 4
and page_is_redirect = 0
and C.tl_title is null
and A.pl_title is null;
SQL

Checking query status...
