Orphaned Feb09 articles with 123 or more incoming mainspace links, no dabs

SQL

SELECT p.page_title, COUNT(pl.pl_from)
FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = "Orphaned_articles_from_February_2009"
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
INNER JOIN categorylinks c2 ON pl.pl_from = c2.cl_from and 
AND pl.pl_from_namespace = 0 and p2.page_is_redirect=0
AND c2.cl_to <> "All_disambiguation_pages" and c2.cl_to <> "All_set_index_articles"
GROUP BY p.page_title
having COUNT(pl.pl_from)>2
ORDER BY COUNT(pl.pl_from) DESC

SQL

Checking query status...