USE arwiki_p;

SELECT 

    page_title,(select count(pl_from) from pagelinks 

                inner join redirect

                on page_title = rd_title 

                where pl_from_namespace = 0

                and pl_title = page_title               

                and pl_namespace = 0

                and rd_namespace = 0)

FROM page 

inner join categorylinks

on cl_from = page_id

and page_namespace = 0

and page_is_redirect = 0

and cl_to like "%جميع_المقالات_اليتيمة%"

limit 10;