Articles with redirected talk pages

SQL

SELECT Pa.page_title AS "article_title", rd_title AS "talk_redirect_target"
FROM page Pt
JOIN page Pa ON Pa.page_namespace=0 AND Pa.page_title=Pt.page_title AND Pa.page_is_redirect=0
JOIN redirect ON rd_from=Pt.page_id
LEFT JOIN categorylinks CLa ON CLa.cl_from=Pa.page_id AND CLa.cl_type="page" AND CLa.cl_to="All_redirects_for_discussion"
LEFT JOIN categorylinks CLt ON CLt.cl_from=Pt.page_id AND CLt.cl_type="page" AND CLt.cl_to="Redirects_from_remote_talk_pages"
WHERE Pt.page_namespace=1 AND Pt.page_is_redirect=1 AND CLa.cl_from IS NULL AND CLt.cl_from IS NULL
ORDER BY Pa.page_title
SQL

Checking query status...
