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