select * from page p1

where p1.name_space = 0 and p1.page_id in (

  select cl_from from categorylinks

  where cl_to in ("All_disambiguation_pages", "All_set_index_articles") and cl_type = 'page'

)

and exists (

  select 1 from pagelinks join page p2 on p2.page_title = pl_title and p2.name_space = pl_namespace

  join redirect on rd_from = p2.page_id and rd_title = p1.page_title and rd_namespace = 0

  where pl_from = p1.page_id and pl_from_namespace = 0

)

limit 1