Untitled query #26330

SQL

USE enwiki_p;
select a.page_id as talk, a.page_title, p2.page_id as article from
(SELECT tp.page_id, tp.page_title
FROM page tp
INNER JOIN categorylinks cl1
 ON tp.page_id=cl1.cl_from
LEFT JOIN categorylinks cl2
 ON tp.page_id = cl2.cl_from AND cl2.cl_to = 'Redirect-Class_AFC_articles'
 WHERE cl1.cl_to='Accepted_AfC_submissions'
AND tp.page_is_redirect = 0
 AND tp.page_namespace = 1 
 AND cl2.cl_from is null) a
INNER JOIN page p2
ON a.page_title = p2.page_title AND p2.page_namespace = 0
INNER JOIN templatelinks tl
 ON p2.page_id = tl.tl_from
  AND tl.tl_title = 'Article_for_deletion/dated'
SQL

Checking query status...
