SELECT concat( "Talk:", p.page_title )

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

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

ORDER by p.page_title

LIMIT 3000;