Untitled query #77966

SQL

SELECT DISTINCT 
  
 -- article.page_title,
--  talk.page_title,
  alias.page_title
FROM
  redirect 
     join page as alias  on rd_from = alias.page_id and alias.page_namespace = 0 and rd_namespace = 0 and rd_interwiki = NULL
 --    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
  article.page_title = talk.page_title AND
  article.page_namespace = 0 AND
  talk.page_namespace = 1

LIMIT
  10
SQL

Checking query status...
