Important articles without portal links

SQL

SELECT Pp.page_title AS Portal, SUBSTRING_INDEX(Ct.cl_to, "-", 1) AS Importance, Pa.page_title AS Article
FROM categorylinks Cp
JOIN page Pp ON Pp.page_namespace=100 AND Pp.page_id=Cp.cl_from AND Pp.page_title="2010s"
JOIN categorylinks Ct ON Ct.cl_type="page" AND Ct.cl_to IN
 (CONCAT("Top-importance_",Pp.page_title,"_articles"), CONCAT("High-importance_",Pp.page_title,"_articles"))
JOIN page Pt ON Pt.page_id=cl_from AND Pt.page_namespace=1 /* Talk page */
JOIN page Pa ON Pa.page_namespace=0 AND Pa.page_title=Pt.page_title /* Article */
WHERE Cp.cl_type="page" AND Cp.cl_to="Portals_needing_placement_of_incoming_links"
AND NOT EXISTS (SELECT 1 FROM pagelinks WHERE pl_from=Pa.page_id AND pl_title="2010s" AND pl_namespace=100)
ORDER BY Portal, Importance DESC, Article
SQL

Checking query status...
