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
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 p.page_title NOT IN (SELECT p.page_title
                         FROM categorylinks
                         INNER JOIN page p ON p.page_id = cl_from
                         WHERE cl_to = "Redirects_for_discussion_with_talk_page_redirects"))
ORDER by p.page_title
LIMIT 3000;

SQL

Checking query status...