trwiki:Unexisting Mirada articles by Vikiprojes

SQL

USE trwiki_p;
SELECT pl_title, GROUP_CONCAT(DISTINCT pap_project_title SEPARATOR ", ") AS projects
FROM pagelinks
INNER JOIN page_assessments ON pl_from=pa_page_id AND pl_from_namespace = 0 AND pl_namespace = 0
INNER JOIN page_assessments_projects ON pa_project_id=pap_project_id
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)
GROUP BY pl_title
ORDER BY pl_title ASC;

SQL

Checking query status...