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

              p.page_title, "}}&redirect=no Talk:", p.page_title, "] redirects to [[Talk:", r.rd_title, "]]  Cat: ", cl.cl_to )

AS "Articles with talk page redirects"

FROM redirect r

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

INNER JOIN page mp ON p.page_title = mp.page_title

INNER JOIN categorylinks cl ON cl.cl_from = p.page_id

WHERE mp.page_namespace = 0

AND   p.page_namespace = 1

AND   r.rd_namespace = 1

AND   mp.page_is_redirect = 0

AND   p.page_title != r.rd_title

#AND   cl.cl_to = "Redirects_for_discussion_with_talk_page_redirects"

ORDER by p.page_title

LIMIT 3000;