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

WITH pairs AS (WITH tempTransesNav AS (SELECT * FROM templatelinks
INNER JOIN linktarget
ON tl_target_id = lt_id
INNER JOIN page
ON tl_from = page_id
WHERE page_namespace = 10 AND lt_namespace = 10 AND lt_title = "Navbox"
                       LIMIT 1)
               (SELECT (SELECT page_id FROM page WHERE page_namespace = 0 AND page_title = pl_title) AS pID, tl_from AS tID FROM pagelinks
INNER JOIN tempTransesNav
 ON pl_from = page_id
 WHERE pl_namespace = 0
                Limit 1))
 (SELECT * FROM templatelinks
                    WHERE tl_from_namespace = 0 
                    AND tl_from = pairs.pID
                    AND (SELECT lt_title FROM linktarget WHERE lt_id = tl_target_id) = pairs.tID)

SQL

Checking query status...