Articles with talk page redirects

Fork of Talk-to-mainspace redirects, except subpages by Wbm1058

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

SQL

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, "]]" )
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;

SQL

Checking query status...