Pages in category X in article and category Y on talk page

Fork of Non-redirects in redirect only category (narrow) by Novem Linguae

This query is marked as a draft This query has been published by Novem Linguae.

SQL

SELECT Pa.page_title
FROM categorylinks
JOIN page Pa ON Pa.page_namespace = 0 AND Pa.page_id = cl_from
-- category 1 (categorized page in main namespace)
WHERE cl_to = "Redirects_with_possibilities"
AND EXISTS (
  SELECT 1
  FROM page Pt2
  WHERE Pt2.page_title = Pa.page_title
  AND Pt2.page_namespace = 1
)
AND EXISTS (
  SELECT 1
  FROM page Pt, categorylinks
  WHERE Pt.page_title = Pa.page_title
  AND Pt.page_namespace = 1
  AND cl_from = Pt.page_id
  -- category 2 (categorized page in talk namespace)
  AND cl_to = "Redirect-Class_Green_Bay_Packers_articles"
)

SQL

Checking query status...