trwiki:Unexisting Mirada articles in vital articles lists

SQL

USE trwiki_p;
SELECT pl_title#, COUNT(pl_title) AS counting
FROM pagelinks
#INNER JOIN page ON pl_from = page_id AND pl_from_namespace = 0 AND pl_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_title IN (SELECT pl_title FROM pagelinks 
                 WHERE 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 counting > 19
ORDER BY /*counting DESC, */pl_title ASC, page_title ASC;

SQL

Checking query status...