SELECT lt.lt_title AS Target, COUNT(IF(page_title IS NULL, 1, NULL)) AS LinkCount

FROM pagelinks pl

​

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

LEFT OUTER JOIN templatelinks tl ON pl.pl_target_id = tl.tl_target_id

​

WHERE pl_from_namespace = 0 AND lt.lt_namespace = 0 AND tl.tl_target_id IS NULL

GROUP BY Target

HAVING LinkCount > 500

ORDER BY LinkCount DESC

LIMIT 10;