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, pl_title from page, pagelinks
where pl_namespace = 14 and pl_from_namespace = 14 and page_id = pl_from
and pl_from in (select tl_from from templatelinks where tl_target_id = 32167)
and pl_title not in (select page_title from page where page_namespace = 14);
*/
select lt_id from linktarget where lt_title = 'Category_redirect' and lt_namespace = 10
SQL

Checking query status...
