SQL
AخA
SELECT page_title
FROM page
WHERE page_namespace = 0 -- main namespace
AND page_is_redirect = 0 -- exclude redirects
AND NOT EXISTS (SELECT 1
FROM categorylinks
WHERE cl_from = page_id
AND cl_to = 'All_article_disambiguation_pages') -- not in this category; change spaces to underscores
LIMIT 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.