USE enwiki_p;

SELECT p.page_title AS page, COUNT(link.pl_from) AS count

FROM page p

INNER JOIN categorylinks c ON p.page_id = c.cl_from

AND c.cl_to = 'All_orphaned_articles'

INNER JOIN pagelinks link ON p.page_title = link.pl_title

AND p.page_namespace = link.pl_namespace

INNER JOIN page p2 ON p2.page_id = link.pl_from

WHERE

link.pl_from_namespace = 0

AND p2.page_is_redirect = 0

GROUP BY

p.page_title

HAVING

COUNT(link.pl_from) > 2

ORDER BY

COUNT(link.pl_from) DESC, p.page_title ASC;