Empty cats 2.0

SQL

use fawiki_p;

create temporary table excludedtpl
select tl_from
from templatelinks
where tl_namespace = 10
and tl_title in (
  'رده_خالی' , 'رده_بهتر', 'رده_ابهام‌زدایی', 'رده_ردیابی‌کردن'
);

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 excludedtpl
on tl_from = page_id
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...
