/*

select p1.page_title from page p1

join page p2 on p2.page_title = p1.page_title and p2.page_namespace = 1 and p2.page_is_redirect = 0

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

and p1.page_id in (

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

)

and p2.page_id not in (

  select tl_from from templatelinks where tl_target_id in (

    select lt_id from linktarget where lt_title = 'WikiProject_Disambiguation' and lt_namespace = 10

  )

)

and p2.page_id in (

  select cl_from from categorylinks where cl_to = 'WikiProject_Disambiguation_pages' and cl_type = 'page'

)

*/

​

select page_namespace, page_title from page where page_is_redirect = 1

and page_id in (

  select cl_from from categorylinks where cl_to = 'WikiProject_Disambiguation_pages' and cl_type = 'page'

)