Redirects to disambiguation pages that are not dab pages

Fork of Redirects to disambiguation pages that are not dab pages by Wbm1058

This query is marked as a draft This query has been published by Certes.

SQL

#SELECT concat( "[https://en.wikipedia.org/w/index.php?title={{urlencode:",
#              p.page_title, "}}&redirect=no", p.page_title, "]" )
SELECT p.page_title
AS "Redirects to disambiguation pages that aren't disambiguation pages"
FROM redirect r
INNER JOIN page p ON p.page_id = r.rd_from
#FROM categorylinks
INNER JOIN categorylinks c ON p.page_id = c.cl_from
#LEFT JOIN page p ON (cl_from = p.page_id)
#WHERE cl_to = "Redirects_for_discussion_with_talk_page_redirects"
WHERE c.cl_to = "Redirects_to_disambiguation_pages"
#AND p.page_title NOT IN (SELECT p.page_title
#                        FROM categorylinks
#                        INNER JOIN page p ON p.page_id = cl_from
#                        WHERE cl_to = "All_disambiguation_pages")
ORDER by p.page_title
LIMIT 200;

SQL

Checking query status...