Untitled query #19952

SQL

#USE stopthisrun;
USE commonswiki_p;
SELECT CONCAT ('[[Category:', REPLACE (page_title,'_',' '), ']]') AS touchlist FROM page
INNER JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 14
AND page_is_redirect = 0
AND page_title NOT IN (SELECT excl.page_title FROM page AS excl
 WHERE excl.page_namespace = 14
 AND excl.page_title NOT IN ('Disambiguation_galleries',
                        'Disambiguation_categories_of_churches_in_Sweden',
                        'Disambiguation_categories_of_populated_places',
                        'Disambiguation_categories_of_temples_in_Japan',
                        'Files_moved_from_de.wikipedia_to_Commons_requiring_review_-_No_timestamp_given'
                        'Non-empty_disambiguation_categories',
                        'Tagged_ambiguous')
 AND excl.page_title NOT LIKE 'Undelete_in%'
)
AND cl_to = 'Disambiguation'                                     #cats from here
AND EXISTS (SELECT 1 FROM categorylinks                          #which are not empty
           WHERE cl_to = page_title)
AND NOT EXISTS (SELECT 1 FROM categorylinks                      #and are not yet listed...
                WHERE cl_from = page_id
                AND cl_to = 'Non-empty_disambiguation_categories'); #...here
SQL

Checking query status...
