Empty Categories on Arabic wiki

Fork of Categories that have the highest number of orphan articles by ASammour

This query is marked as a draft This query has been published by إسلام.

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

SQL

Checking query status...