WIP: exclude navboxes from orphan search

SQL

USE enwiki_p;
SELECT p.page_title
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "All_orphaned_articles"
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
LEFT JOIN (
    SELECT DISTINCT pl.pl_from AS page_id
    FROM pagelinks pl
    WHERE pl.pl_namespace = 10  -- Assuming that navboxes are in namespace 10
) navbox_pages ON pl.pl_from = navbox_pages.page_id
WHERE pl.pl_from_namespace = 0 AND p.page_is_redirect = 0
    AND navbox_pages.page_id IS NULL  -- Exclude links from pages in the navbox
GROUP BY p.page_title
HAVING COUNT(pl.pl_from) > 1
ORDER BY COUNT(pl.pl_from) DESC, p.page_title;
SQL

Checking query status...
