Articles that are soft redirects

SQL

select distinct page_title
from page  
, category as catdepth1a
, 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 catdepth1a)
and catdepth3 in (select cat_title from catdepth2)
and catdepth4 in (select cat_title from catdepth3)
and catdepth5 in (select cat_title from catdepth4)
and catdepth6 in (select cat_title from catdepth5)
and (cl.to in (select cat_title from catdepth1a))
limit 50
SQL

Checking query status...
