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://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")
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;

Articles with talk page redirects
Talk:Bangladeshis_held_in_the_Guantanamo_detention_camps redirects to Talk:List_of_Guantanamo_Bay_detainees
Talk:Cassette_tape_(format) redirects to Talk:List_of_cassette_tape_and_cartridge_tape_formats
Talk:List_of_Shen_Gong_Wu_revealed_in_Season_Three redirects to Talk:Xiaolin_Showdown
Talk:Maple_Leaf_Wrestling redirects to Talk:Maple_Leaf_Pro_Wrestling
Talk:Melodye redirects to Talk:Suikoden_(video_game)
Talk:Milia_(Suikoden) redirects to Talk:Suikoden_(video_game)
Talk:Milich_Oppenheimer redirects to Talk:Suikoden_(video_game)
Talk:Nash_Latkje redirects to Talk:Suikoden_(video_game)
Talk:Neclord redirects to Talk:Suikoden_(video_game)
Talk:Pesmerga redirects to Talk:Suikoden_(video_game)
Talk:Playhouse_Disney_around_the_world redirects to Talk:Disney_Junior_(international)
Talk:Richard_Mansergh_St_George redirects to Talk:Richard_St_George_Mansergh-St_George
Talk:Wharfedale_&_Airedale_Observer redirects to Talk:Gazette_&_Observer