MILHIST biographies

SQL

SELECT CONCAT('Talk:', page_title) AS talk_page
FROM page
WHERE
  page_namespace = 1
  AND page_id IN (
    SELECT tl_from
    FROM templatelinks
    WHERE
      tl_from_namespace = 1
      AND tl_namespace = 10
      AND tl_title IN (
        "WikiProject_Military_History", "WPCAS", "WikiProject_Colditz", "MILHIST", "Milhist", "WP_Military_History",
        "WikiProject_MILHIST", "WikiProject_War", "WP_Military_history", "WPMILHIST", "WPMilhist", "MilHist", "Mil_Hist",
        "WPMH", "WP_Mil", "Military_history", "WPMIL", "WP_MILHIST", "WikiProject_Military"
      )
  )
  AND page_id IN (
    SELECT cl_from
    FROM categorylinks cl
    WHERE cl.cl_to IN ('WikiProject_Biography_articles', 'Biography_articles_of_living_people')
  )
  AND page_id NOT IN (
    SELECT cl_from
    FROM categorylinks cl2
    WHERE cl2.cl_to = 'Military_biography_work_group_articles'
  )
SQL

Checking query status...
