trwiki:SASes closed as delete but article redlinks preserved

SQL

USE trwiki_p;
SELECT pl_title, COUNT(pl_title) AS counting, COUNT(log_id) AS deletions
FROM pagelinks JOIN page p ON pl_from = p.page_id
INNER JOIN page p2 ON pl_title=SUBSTRING(p2.page_title,25)
			AND pl_namespace = 0
			AND p2.page_namespace = 4
			AND p2.page_title LIKE "Silinmeye_aday_sayfalar/%"
INNER JOIN logging ON log_title=pl_title
WHERE pl_from_namespace = 0
AND pl_namespace = 0
AND NOT EXISTS
(SELECT p1.page_title FROM page AS p1
WHERE p1.page_title = pl_title
AND pl_namespace = 0
AND p1.page_namespace = 0)
GROUP BY pl_title
HAVING counting > 0
ORDER BY counting DESC, pl_title ASC, deletions DESC, p.page_title ASC;

SQL

Checking query status...