Untitled query #14182

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 cat_pages > 100
and cl_from in (select cl_from from categorylinks where cl_to = "جميع_المقالات_اليتيمة")
and page.page_namespace = 0
group by cl_from
order by cat_pages ASC
limit 100;
SQL

Checking query status...
