CSD G8 category redirects

SQL

/*
select page_namespace, page_title from categorylinks
join page on cl_from = page_id
where cl_to = 'Wikipedia_soft_redirected_categories' and cl_type != 'subcat'
limit 10;
*/

/*
select page_title, rd_title
from page, pagelinks
where pl_namespace = 14 and pl_from_namespace = 14
and page_id = pl_from
and page_id in (select tl_from from )
   AND rd_interwiki = ''
   AND rd_namespace >= 0
   AND rd_title NOT IN (SELECT page_title FROM page WHERE page_namespace = rd_namespace)
*/

select page_title from templatelinks, linktarget, page
where tl_from = page_id and tl_target_id = lt_id
and lt_title = 'Category_redirect' and lt_namespace = 10 and page_namespace = 14
limit 10;
SQL

Checking query status...
