SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Draft_talk:{{urlencode:",

              p.page_title, "}}&redirect=no Draft talk:", p.page_title, "] redirects to [[", r.rd_title, "]]" )

AS "Redirects from draft talk to mainspace"

FROM redirect r

INNER JOIN page p ON p.page_id = r.rd_from

WHERE p.page_namespace = 119

AND   r.rd_namespace = 0

ORDER by page_title

LIMIT 2000;