Untitled query #77966

SQL

SELECT 
  
  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 c1 ON talk.page_id = c1.cl_from AND c1.cl_to = "WikiProject_New_Zealand_articles"
               
WHERE 
  TRUE
LIMIT
  10
SQL

Checking query status...
