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), tl_from 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 (SELECT page_title FROM page WHERE tl_from = page_id) = pairs.page_id
                    AND (SELECT lt_title FROM linktarget WHERE lt_id = tl_target_id) = pairs.page_title)*/

SQL

Checking query status...