Articles that are soft redirects

SQL

select distinct page_title
from page join categorylinks on cl_from = page_id,
category as catdepth1, 
category as catdepth2
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 (
  categorylinks.cl_to in (select cat_title from category c1 where c1.cat_title = catdepth1.cat_title)
  or (categorylinks.cl_to in (select cat_title from category c2 where c2.cat_title = catdepth2.cat_title))
)
limit 10

SQL

Checking query status...