Most wanted articles: ns0→ns0 redlinks only

SQL

SELECT lt.lt_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCount
FROM pagelinks pl
(LEFT OUTER JOIN templatelinks tl ON pl.pl_target_id = tl.tl_target_id WHERE tl.tl_target_id IS NULL) -- remove template links
INNER JOIN linktarget lt ON pl.pl_target_id = lt.lt_id
LEFT JOIN page ON page_namespace = 0 AND page_title = lt.lt_title
WHERE pl_from_namespace = 0 AND lt.lt_namespace = 0
GROUP BY Target
HAVING LinkCount > 500
ORDER BY LinkCount DESC
LIMIT 100;

AخA
 
SELECT lt.lt_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCountFROM pagelinks pl(LEFT OUTER JOIN templatelinks tl ON pl.pl_target_id = tl.tl_target_id WHERE tl.tl_target_id IS NULL) -- remove template linksINNER JOIN linktarget lt ON pl.pl_target_id = lt.lt_idLEFT JOIN page ON page_namespace = 0 AND page_title = lt.lt_titleWHERE pl_from_namespace = 0 AND lt.lt_namespace = 0GROUP BY TargetHAVING LinkCount > 500ORDER BY LinkCount DESCLIMIT 100;

SQL

Checking query status...