Articles missing Navboxes

SQL

/*SELECT pl_title FROM pagelinks
INNER JOIN page
ON page_id = pl_from
WHERE pl_from_namespace = 828 AND page_title = "Navbox"
Limit 50;*/

WITH tempTransesNav AS (SELECT page_title, page_namespace 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 50)
SELECT page_title FROM tempTransesNav;

/* tl_from FROM templatelinks tl WHERE (SELECT page_title FROM page WHERE page_id=tl.tl_target_id) = "Navbox"
LIMIT 50;*/
# 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 IN (SELECT tl_from FROM templatelinks tl INNER JOIN page p ON p.page_id = tl.tl_target_id WHERE p.page_title = "Navbox" AND tl_from = pl_from)
# and ensure the template isn't something transcluded into another template
#AND NOT EXISTS (SELECT tl_from FROM templatelinks WHERE tl_title = (SELECT page_title FROM page WHERE page_id = pl_from) AND tl_from_namespace = 10)
# 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 IN (SELECT tl_title FROM templatelinks WHERE tl_from = page_id)
# and not a redirect
AND page_is_redirect = 0
LIMIT 200;*/

#SELECT page_title FROM page WHERE page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from_namespace = 10) LIMIT 50;

#SELECT (SELECT page_title FROM page WHERE page_id=tl_from) FROM templatelinks WHERE tl_title IN (SELECT page_title FROM page WHERE page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from_namespace = 10)) AND tl_from_namespace = 10 LIMIT 50;

#(SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from_namespace = 10 AND tl_namespace = 10)
#EXCEPT 
#(SELECT tl_from FROM templatelinks WHERE tl_title IN (SELECT page_title FROM page WHERE page_id IN (SELECT tl_from FROM templatelinks WHERE tl_title = "Navbox" AND tl_from_namespace = 10)) AND tl_from_namespace = 10) LIMIT 50;
#(SELECT page_title FROM page WHERE page_id = tl_from)
SQL

Checking query status...
