This query is marked as a draft This query has been published by Mackensen.

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.

Checking query status...