Inactive project page links

SQL

select src.page_title, dst.page_title as "link_title", cl_to from pagelinks
join page src on src.page_id=pl_from
join linktarget on lt_id=pl_target_id
join page dst on dst.page_namespace=lt_namespace and dst.page_title=lt_title
join categorylinks on cl_from=dst.page_id
where lt_namespace = 4
and pl_from_namespace = 0
and cl_to="Inactive_project_pages"
and src.page_is_redirect=0
and not exists (select 1 from pagelinks join linktarget on lt_id=pl_target_id where pl_from=77958231 and lt_namespace=0 and lt_title=src.page_title)
limit 1000
SQL

Checking query status...
