Articles missing Navboxes

Articles which are linked to from a navbox template, but do not transclude said template.

Generates some false positives, such as Coord/speedtest, which I haven't found a workaround for.

SQL

# select pages and link creators
SELECT
page_title AS "Page Name",
(SELECT page_title FROM page WHERE page_id = pl_from) AS "Nav Template"
FROM page
JOIN pagelinks
ON pl_title = page_title
# with links incoming from templatespace
WHERE pl_from_namespace = 10
# and is in article space
AND page_namespace = 0
AND pl_from IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from = pl_from)
AND (SELECT page_title FROM page WHERE page_id = pl_from) NOT IN (SELECT tl_title FROM templatelinks WHERE tl_from = page_id)

Limit 200;

SQL

Checking query status...