Untitled query #26305

SQL

USE enwiki_p;


select * from
(SELECT distinct tp.page_id
FROM page tp
JOIN categorylinks
ON tp.page_id=cl_from
WHERE cl_to='Accepted_AfC_submissions'
AND tp.page_is_redirect = 0
  AND tp.page_namespace = 1) a
left join
(
SELECT distinct tp.page_id
FROM page tp
JOIN categorylinks
ON tp.page_id=cl_from
JOIN page ap
ON (tp.page_title=ap.page_title
    AND ap.page_namespace=0)
WHERE cl_to='Accepted_AfC_submissions'
  AND ap.page_is_redirect=0) b
on a.page_id = b.page_id
where b.page_id is null
limit 100;
SQL

Checking query status...
