Talk-to-mainspace redirects, except subpages

SQL

SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Talk:{{urlencode:",
              p.page_title, "}}&redirect=no Talk:", p.page_title, "] redirects to [[:", r.rd_title, "]]" )
AS "Talk-to-mainspace redirects, except subpages"
FROM redirect r
INNER JOIN page p ON p.page_id = r.rd_from
WHERE p.page_namespace = 1
AND   r.rd_namespace = 0
AND   p.page_title NOT LIKE '%/%'
ORDER by page_title;

AخA
 
SELECT concat( "[https://en.wikipedia.org/w/index.php?title=Talk:{{urlencode:",              p.page_title, "}}&redirect=no Talk:", p.page_title, "] redirects to [[:", r.rd_title, "]]" )AS "Talk-to-mainspace redirects, except subpages"FROM redirect rINNER JOIN page p ON p.page_id = r.rd_fromWHERE p.page_namespace = 1AND   r.rd_namespace = 0AND   p.page_title NOT LIKE '%/%'ORDER by page_title;

SQL

Checking query status...