Pages of WikiProject Catholicism with redlinks

SQL

SELECT templatepage.page_title
FROM page talkpage

INNER JOIN categorylinks ON talkpage.page_id = categorylinks.cl_from
INNER JOIN page mainpage ON mainpage.page_title = talkpage.page_title
INNER JOIN pagelinks articlelinks ON mainpage.page_id = articlelinks.pl_from
INNER JOIN pagelinks templatelinks ON articlelinks.pl_title = templatelinks.pl_title
INNER JOIN page templatepage ON templatelinks.pl_from = templatepage.page_id

WHERE categorylinks.cl_to = "WikiProject_Catholicism_articles"
AND articlelinks.pl_namespace = 0 AND mainpage.page_namespace = 0 AND talkpage.page_namespace = 1
AND articlelinks.pl_title NOT IN (SELECT page_title FROM page WHERE page.page_namespace = 0)

SQL

Checking query status...