SQL
AخA
select origin_page.page_title as origin_page, rd_title as target_page
from categorylinks AS cl1
inner join redirect on rd_from = cl1.cl_from
inner join page as origin_page on origin_page.page_id = cl1.cl_from
inner join page as target_page on target_page.page_namespace = rd_namespace and target_page.page_title = rd_title
inner join categorylinks AS cl2 ON cl2.cl_from = target_page.page_id AND cl2.cl_to = "All_disambiguation_pages"
where cl1.cl_to = "Redirects_connected_to_a_Wikidata_item"
limit 50;
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.