select p1.page_title, p2.page_title from page p1

join pagelinks on pl_from = p1.page_id and pl_from_namespace = 0

join page p2 on p2.page_title = pl_title and p2.page_namespace = pl_namespace

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

where p1.page_namespace = 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 p1.page_id not in (

  select cl_from from categorylinks

  where cl_to in ("Disambiguation_pages_to_be_converted_to_broad_concept_articles") and cl_type = "page"

)

and p1.page_id not in (

  select tl_from from templatelinks join linktarget on tl_from_namespace = 2 and tl_target_id = lt_id

  where lt_namespace = 10 and lt_title in (

    select page_title from categorylinks join page on cl_from = page_id and page_namespace = 10

    where cl_to = 'Disambiguation_and_redirection_templates' and cl_type = 'page'

  )

)