Mainspace pages in cat tree w/ talk page in cat

SQL

WITH RECURSIVE maincattree AS (
  SELECT cl.cl_from
  FROM categorylinks cl
  WHERE cl.cl_to = 'Clean-up_categories_from_2013' -- Change as needed
  UNION
  SELECT cl.cl_from
  FROM categorylinks cl
  INNER JOIN page p ON cl.cl_to = p.page_title AND p.page_namespace = 14
  INNER JOIN maincattree mct ON mct.cl_from = p.page_id
),
talkcat AS (
  SELECT cl.cl_from
  FROM categorylinks cl
  WHERE cl.cl_to = 'WikiProject_Louisville_articles' -- Change as needed
)
SELECT CONCAT('[[', p.page_title, ']]') AS 'Article'
FROM page p
INNER JOIN page tp ON p.page_title = tp.page_title AND tp.page_namespace = 1
WHERE p.page_namespace = 0
AND p.page_id IN (SELECT mct.cl_from FROM maincattree mct)
AND tp.page_id IN (SELECT tc.cl_from FROM talkcat tc)
ORDER BY p.page_title ASC
SQL

Checking query status...
