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 pl_title AS ptitle, (SELECT page_title FROM page WHERE page_id = tl_from) AS ntitle FROM pagelinks
INNER JOIN tempTransesNav
 ON pl_from = page_id
 WHERE pl_namespace = 0
 Limit 50))
 (SELECT * FROM pairs
  WHERE NOT EXISTS (SELECT * FROM templatelinks 
                    WHERE tl_from_namespace = 0 
                    AND (SELECT page_title FROM page WHERE tl_from = page_id) = pairs.ptitle
                    AND (SELECT lt_title FROM linktarget WHERE lt_id = tl_target_id) = pairs.ntitle)
 LIMIT 50)

SQL

Checking query status...