trwiki:SASes closed as delete but article redlinks preserved

SQL

USE trwiki_p;
SELECT pl_title, COUNT(pl_title) AS counting
FROM pagelinks, page
WHERE pl_from = page_id
AND 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)
AND EXISTS (SELECT SUBSTRING(p2.page_title,25) FROM page AS p2
            WHERE SUBSTRING(p2.page_title,25)=pl_title
			AND pl_namespace = 0
			AND p2.page_namespace = 4
			AND p2.page_title LIKE "Silinmeye_aday_sayfalar/%")
GROUP BY pl_title
HAVING counting > 0
ORDER BY counting DESC, pl_title ASC, page_title ASC LIMIT 1;

SQL

Checking query status...