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 categpry c1 where c1.cat_title = catdepth1.cat_title)

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 catdepth1b))

limit 50