use arwiki_p;

select DISTINCT  cat_pages as "عدد الصفحات", cat_title as "التصنيف" ,COUNT(cl_from) as "عدد المقالات اليتيمة" from category 

inner join page

on page.page_title = category.cat_title

inner join categorylinks 

on categorylinks.cl_to = page.page_title

where  cl_from in (select cl_from from categorylinks where cl_to = "جميع_المقالات_اليتيمة" and cl_from = cl_from)

group by cat_title

order by cat_pages ASC

limit 500;