Articles with "orphan" tag, that has 2 or more incoming link (arwiki)

SQL

USE arwiki_p;

SELECT p.page_title, COUNT(pl.pl_from) as pl.pl_from

FROM page p

#limit results to a sepecifc category
INNER JOIN categorylinks c ON p.page_id = c.cl_from 

#limit results to pagelinks pl_from > 2, see below
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title 

#limit results to when linked page != redirect and an article
INNER JOIN page p2 ON p2.page_id = pl.pl_from 


WHERE p.page_namespace = 0 AND c.cl_to = "جميع_المقالات_اليتيمة" AND pl.pl_from_namespace = 0 AND  pl.pl_namespace = 0  AND p2.page_is_redirect=0

GROUP BY p.page_title # ? 

#only pages with pagelinks > 2
having COUNT(pl.pl_from)>2

#ORDER BY COUNT(pl.pl_from) DESC# this takes so long

Limit 200;

SQL

Checking query status...