SQL
AخA
/*
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 * from templatelinks, linktarget
where tl_target_id = lt_id and lt_title = 'Category_redirect' and lt_namespace = 10
limit 1;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.