trwiki:Unexisting Mirada articles in vital articles lists

SQL

USE trwiki_p;
SELECT CONCAT("[[",REPLACE(pl_title,"_"," "),"]] (",arc.ar_len," bayt)") as Madde, (CASE
  WHEN pl_from=7662 THEN "1000"
  WHEN pl_from=1471960 THEN "Kişiler"
  WHEN pl_from=1472822 THEN "Tarih"
  WHEN pl_from=1472900 THEN "Coğrafya"
  WHEN pl_from=1472903 THEN "Sanat"
  WHEN pl_from=1472527 THEN "Felsefe ve Din"
  WHEN pl_from=1472914 THEN "Antropoloji, psikoloji ve günlük hayat"
  WHEN pl_from=1472538 THEN "Toplum ve sosyal bilimler"
  WHEN pl_from=1472757 THEN "Biyoloji ve sağlık bilimleri"
  WHEN pl_from=1472912 THEN "Fiziksel bilimler"
  WHEN pl_from=1472302 THEN "Teknoloji"
  WHEN pl_from=1472357 THEN "Matematik"
  WHEN pl_from=1471952 THEN "Ölçüm"
#  ELSE (SELECT page_title FROM page WHERE page_id=pl_from)
  END) AS Liste
FROM pagelinks
JOIN archive AS arc ON 
ar_title=pl_title 
AND ar_timestamp <= (SELECT TIMESTAMP("2017-03-29 16:26:55")) 
AND ar_id=(SELECT MAX(ar_id) FROM archive AS a1 WHERE a1.ar_title=arc.ar_title AND ar_namespace=0 AND ar_timestamp <= (SELECT TIMESTAMP("2017-03-29 16:26:55")))
AND ar_namespace=0
WHERE 
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 pl_title IN (SELECT pl_title FROM pagelinks WHERE pl_from = 2219492 AND pl_from_namespace = 4 
AND pl_namespace = 0)
AND pl_from IN (7662,1471960,1472822,1472900,1472903,1472527,1472914,1472538,1472757,1472912,1472302,1472357,1471952)
AND pl_from_namespace = 4 
AND pl_namespace = 0

GROUP BY pl_title# HAVING cat NOT IN ("-")
ORDER BY pl_title ASC;
SQL

Checking query status...
