SQL
AخA
select
p1.page_title as "disambiguation",
p2.page_title as "redirect",
rd_title as "target",
rd_interwiki,
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
pp_propname = "disambiguation" and
rd_namespace = 0 and rd_interwiki != ""
limit 10;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.