Articles missing Navboxes

SQL

# select page titles and template titles
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 the incoming template is /probably/ an infobox template
AND pl_from EXISTS (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from = pl_from)
AND (SELECT page_id FROM page WHERE page_title EXISTS (SELECT tl_title FROM templatelinks WHERE tl_from = pl_from)) NOT EXISTS (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox")
# check that the original page can "see" the Navbox, to work around <noinclude>ed stuff like /doc pages including navboxes
#AND page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from = page_id)
# and the page doesn't transclude the template
AND (SELECT page_title FROM page WHERE page_id = pl_from) NOT EXISTS (SELECT tl_title FROM templatelinks WHERE tl_from = page_id)
LIMIT 50;
SQL

Checking query status...
