Most wanted articles: ns0→ns0 redlinks only

Fork of Most wanted articles: ns0→ns0 redlinks only by Certes

This query is marked as a draft This query has been published by Certes.

SQL

SELECT pl_title Target, SUM(page_title IS NULL) LinkCount
FROM pagelinks PLa
LEFT JOIN page ON page_namespace=0 AND page_title=pl_title
WHERE pl_from_namespace=0 AND pl_namespace=0 AND pl_title like "Ab%"
AND NOT EXISTS (SELECT 1 FROM templatelinks /* Same article links to same redlink via any template */
                WHERE tl_from=PLa.pl_from
                JOIN linktarget ON lt_id=tl_target_id AND lt_namespace=10
                JOIN page Pt ON Pt.page_namespace=10 AND Pt.page_title=lt_title
                JOIN pagelinks PLt ON PLt.pl_from=Pt.page_id AND PLt.pl_namespace=0 AND PLt.pl_title=PLa.pl_title)
GROUP BY Target
HAVING LinkCount>500
ORDER BY LinkCount DESC

SQL

Checking query status...