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 = "Orphaned_articles_from_June_2024"

JOIN linktarget ON p.page_title = lt_title AND p.page_namespace = lt_namespace

JOIN pagelinks pl ON lt_id = pl_target_id

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

AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0

GROUP BY p.page_title

having COUNT(pl.pl_from)>1

ORDER BY COUNT(pl.pl_from) desc, p.page_title;