SQL
AخA
SELECT DISTINCT page1.page_title AS title
FROM page as page1
JOIN pagelinks
ON page1.page_id = pagelinks.pl_from
AND page1.page_namespace = 0
JOIN page AS page2
ON pagelinks.pl_namespace = page2.page_namespace
AND pagelinks.pl_title = page2.page_title
JOIN categorylinks
ON page2.page_id = categorylinks.cl_from
AND categorylinks.cl_to = 'Disambiguation pages'
AND NOT EXISTS (SELECT *
FROM categorylinks AS cl1
WHERE cl1.cl_from = page1.page_id
AND cl1.cl_to = 'Disambiguation pages')
AND NOT page2.page_title LIKE "%_(disambiguation)"
AND page1.page_is_redirect = 0
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.