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_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