Untitled query #77966

SQL

SELECT DISTINCT
  
  article.page_title,
  alias.page_title
--  count(alias.page_title),
--  count(DISTINCT talk.page_title)
FROM
  redirect 
    JOIN page AS alias  ON rd_from = alias.page_id AND alias.page_namespace = 0 AND rd_namespace = 0
    JOIN page AS article ON article.page_title = rd_title AND article.page_namespace = 0
    JOIN page AS talk ON article.page_title = talk.page_title AND talk.page_namespace = 1
    JOIN categorylinks AS c1 ON talk.page_id = c1.cl_from AND c1.cl_type = "page" AND c1.cl_to = "WikiProject_New_Zealand_articles"
    LEFT OUTER JOIN categorylinks AS c2 ON talk.page_id = c2.cl_from AND c2.cl_type = "page" AND c2.cl_to = "WikiProject_Biography_articles"
WHERE 
  TRUE
LIMIT
  30
SQL

Checking query status...
