SELECT

  title_query.page_id,

  title_query.page_title,

  redir_query.page_redirects

FROM (

SELECT DISTINCT article.page_id AS page_id, article.page_title AS page_title

FROM page talk

INNER JOIN page article ON

  talk.page_title = article.page_title

INNER JOIN categorylinks ON

  cl_from = talk.page_id

WHERE

  talk.page_namespace = 1 AND

  article.page_namespace = 0 AND

  cl_to = "WikiProject_Women's_Health_articles"

) AS title_query

INNER JOIN

  (SELECT rd_title AS title, COUNT(*) AS page_redirects

  FROM redirects

  WHERE rd_namespace IN(0, 1)

  GROUP BY rd_title, rd_namespace) AS redir_query

ON title_query.page_title = redir_query.title;

​