User:Wbm1058/Articles with talk page redirects
- See also: alternative Quarry query to generate a simple list
Excluded from the report are centralized talk pages that transclude {{R from remote talk page}}.
Report generated from Quarry by running:
SELECT concat( "[https://wiki.riteme.site/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")
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_from_remote_talk_pages")
ORDER by p.page_title
LIMIT 3000;