Match category with template

SQL

/*
select cat_title, to_base64(cat_title) from category
where cat_title not in (select page_title from page where page_namespace = 14) and cat_pages = 0;
*/

select page_namespace, page_title from page
where page_id in (select cl_from from categorylinks where cl_to = 'Wikipedia_soft_redirected_categories')
and page_id not in (select tl_from from templatelinks where tl_target_id in (
  select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
))
order by page_namespace

SQL

Checking query status...