SELECT DISTINCT mainpage.page_title

FROM categorylinks outercat

INNER JOIN page outerpage ON outerpage.page_id = outercat.cl_from

INNER JOIN categorylinks innercat ON outerpage.page_title = innercat.cl_to

INNER JOIN page talkpage ON talkpage.page_id = innercat.cl_from

INNER JOIN page mainpage ON mainpage.page_title = talkpage.page_title

WHERE outercat.cl_to = "Redirect-Class_articles"

AND talkpage.page_namespace = 1

AND mainpage.page_namespace = 0

AND mainpage.page_is_redirect = 0

AND mainpage.page_id NOT IN (

  SELECT innersoftcat.cl_from

  FROM categorylinks outersoftcat

  INNER JOIN page softcatpage ON softcatpage.page_id = outersoftcat.cl_from

  INNER JOIN categorylinks innersoftcat ON innersoftcat.cl_to = softcatpage.page_title

  WHERE outersoftcat.cl_to = "Wikipedia_interwiki_soft_redirects"

  AND softcatpage.page_namespace = 14

)

AND "Temporary_maintenance_holdings" NOT IN (SELECT cl_to FROM categorylinks WHERE cl_from = mainpage.page_id)

AND "Requested_RD1_redactions" NOT IN (SELECT cl_to FROM categorylinks WHERE cl_from = mainpage.page_id)