Articles that are soft redirects

SQL

select distinct page_title
from page  
, category as catdepth1
, category as catdepth2
, category as catdepth3
, category as catdepth4
, category as catdepth5
, category as catdepth6
join templatelinks t1 on t1.tl_from = page_id
join categorylinks cl on cl.cl_from = page_id
where page_namespace = 0
and page_is_redirect = 0
and catdepth1.cat_title = "Redirect_templates"
and catdepth2 in (select cat_title from category c1 where c1.cat_title = catdepth1.cat_title)
and catdepth3 in (select cat_title from category c2 where c2.cat_title = catdepth2.cat_title)
and catdepth4 in (select cat_title from category c3 where c3.cat_title = catdepth3.cat_title)
and catdepth5 in (select cat_title from category c4 where c4.cat_title = catdepth4.cat_title)
and catdepth6 in (select cat_title from category c5 where c5.cat_title = catdepth5.cat_title)
and (cl.to in (select cat_title from category c1 where c1.cat_title = catdepth1.cat_title))
limit 50
SQL

Checking query status...
