look for redirects connected to a wikidata item that target a dab page

Redirects in [[Category:Redirects connected to a Wikidata item]] whose targets are in [[Category:All disambiguation pages]].

For [[WP:RAQ#Redirects connected to a Wikidata item that target a disambiguation page]] circa 24 April 2024.

SQL

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 1000;

SQL

Checking query status...