SQL
x
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)
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.