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( "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;