Untitled query #80558

SQL

select
  page_r.page_namespace as redirect_namespace,
  page_r.page_title as redirect_title,
  page_t.page_namespace as target_namespace,
  page_t.page_title as target_title
from
  categorylinks
  join redirect on cl_from = rd_from
  join page page_t on rd_namespace = page_t.page_namespace
  and rd_title = page_t.page_title
  left join page_props on page_t.page_id = pp_page
  and pp_propname = 'disambiguation'
  join page page_r on cl_from = page_r.page_id
where
  cl_to = 'Redirects_to_disambiguation_pages'
  and pp_page is null;
SQL

Checking query status...
