article tagged orphan but has 2 or more links

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
INNER JOIN page p2 ON p2.page_id = pl.pl_from
AND pl.pl_from_namespace = 0 AND p2.page_is_redirect = 0
-- Exclude pages with 'Navbox' templates
WHERE p2.page_title NOT IN (
    SELECT tl_title
    FROM templatelinks
    WHERE tl_namespace = 10 AND tl_title = 'Navbox'
)
GROUP BY p.page_title
HAVING COUNT(pl.pl_from) > 4
ORDER BY COUNT(pl.pl_from) DESC, p.page_title;

SQL

Checking query status...