Untitled query #77966

SQL

-- find redirects to articles covered by WikiProject New Zealand
-- 

SELECT DISTINCT
  
  article.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
    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"
    -- skip redirects to biographies, since I'm TBAN'd  
    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
  100
SQL

Checking query status...
