Categories that have the highest number of orphan articles

SQL

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 COUNT(cl_from) > 50
and 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 100;

SQL

Checking query status...