Untitled query #57977

SQL

select
	p1.page_title as "disambiguation",
    p2.page_title as "redirect",
    rd_title as "target",
    rd_fragment as "fragment"
from pagelinks
	inner join page as p1 on p1.page_id = pl_from
    inner join page_props on p1.page_id = pp_page
    inner join page as p2 on p2.page_title = pl_title
    inner join redirect on p2.page_id = rd_from
where
	pl_from_namespace = 0 and
    pl_namespace = 0 and
    p2.page_namespace = 0 and
    pp_propname = "disambiguation" and
    rd_namespace = 0 and
    rd_interwiki = ""
order by
	p1.page_title,
    p2.page_title;
SQL

Checking query status...
