with disamb_page as (

  select page_title from page

  where page_is_redirect = 0 and page_namespace = 0

  and page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')

),

disamb_redirect as (

  select p1.page_title as rdt_title, p2.page_title as rdf_title from page p1

  join redirect on rd_title = p1.page_title and rd_namespace = 0

  join page p2 on p2.page_id = rd_from and p2.page_namespace = 0 and p2.page_is_redirect = 1

  where p1.page_id in (select cl_from from categorylinks where cl_to = 'All_disambiguation_pages' and cl_type = 'page')

  and p1.page_is_redirect = 0 and p1.page_namespace = 0

)

​

select concat('{{subst:Rfd2|multi=yes|redirect=', REPLACE(dr.rdf_title, '_', ' '), '|target=', REPLACE(dr.rdt_title, '_', ' '), '}}') from disamb_redirect dr

where dr.rdf_title like '%\_(%)\_(disambiguation)'

and substring(dr.rdf_title, 1, INSTR(dr.rdf_title, "_(disambiguation)")-1) in (

  select page_title from disamb_page

  union

  select rdf_title from disamb_redirect

)

order by dr.rdf_title;