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