use arwiki_p;

select cat_pages as "عدد الصفحات", CONCAT ("[[تصنيف:",cat_title,"]]") AS "العنوان" from category 

inner join page

on page.page_title = category.cat_title

where page.page_namespace=14 and category.cat_pages = 0 and category.cat_subcats = 0 and category.cat_files = 0 and page.page_is_redirect = 0

And NOT page.page_id in (select tl_from from templatelinks  where tl_title = 'تحويل تصنيف')

And NOT page.page_id in (select tl_from from templatelinks  where tl_title = 'تصنيف فارغ')

And NOT page.page_id in (select tl_from from templatelinks  where tl_title = 'تصنيف مخفي');