Old orphan articles

SQL

use fawiki_p;
select concat('[[', page_title, ']]'),
str_to_date(left(rev_timestamp, 8), '%Y%m%d'),
count(pl_from),
count(ll_lang)
from page
join revision
on page_latest = rev_id
left join categorylinks
on page_id = cl_from
and cl_to = 'صفحه‌های_ابهام‌زدایی'
left join
(
  select pl_from, pl_title, pl_namespace, pl_from_namespace
  from pagelinks
  join page
  on page_id = pl_from
  and page_is_redirect = 0
) pl
on page_title = pl_title
and pl_namespace = 0
and pl_from_namespace = 0
left join langlinks
on ll_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and rev_timestamp < concat(date_format(date_sub(now(), interval 4 year), '%Y%m%d'), '000000')
and cl_to is null
group by page_title, str_to_date(left(rev_timestamp, 8), '%Y%m%d')
having count(pl_from) = 0
order by rev_timestamp asc
SQL

Checking query status...
