Empty cats - Quarry

SQL

use fawiki_p;
select page_title, count(ll_lang)
from page
join category
on page_title = cat_title
left join categorylinks
on page_title = cl_to
left join templatelinks
on tl_from = page_id
-- and tl_namespace = 10
and tl_title in (
  'رده_خالی' , 'رده_بهتر', 'رده_ابهام‌زدایی', 'رده_ردیابی‌کردن'
)
left join langlinks
on page_id = ll_from
where page_namespace = 14
and page_is_redirect = 0
and cl_to is null
and tl_title is null
group by page_title
order by 2, 1
limit 5000
SQL

Checking query status...
