Untitled query #19728

SQL

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;
SQL

Checking query status...
