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"

)

ORDER BY page_title

​