Untitled query #73465

SQL

SELECT p.page_title
FROM page p
JOIN page c ON p.page_title = c.page_title AND c.page_namespace = 14 -- join with the category page
JOIN categorylinks cl ON c.page_id = cl.cl_from AND cl.cl_to = p.page_title -- join with the category links
WHERE cl.cl_type = "page" -- only include page types in the category
AND p.page_namespace = 0 -- only include articles (not talk pages or other namespaces)
AND p.page_title NOT IN (SELECT cl2.cl_to FROM categorylinks cl2 WHERE cl2.cl_from = c.page_id) -- exclude pages that are already in the category
SQL

Checking query status...
