Categories to be touched on Commons

SQL

USE commonswiki_p;
SELECT CONCAT ('[[Category:', REPLACE (page_title,'_',' '), ']]') AS touchlist FROM page
LEFT JOIN categorylinks ON cl_from = page_id
WHERE page_namespace = 14
AND page_is_redirect = 0
AND page_title NOT IN ('Disambiguation_of_churches_in_Sweden',
                       'Disambiguation_of_temples_in_Japan',
                       'Non-empty_disambiguation_categories',
                       'Tagged_ambiguous')
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 already listed...
                WHERE cl_from = page_id
                AND cl_to = 'Non-empty_disambiguation_categories') #...here
     )
OR   (cl_to = 'Non-empty_disambiguation_categories'                #or cats from here
AND NOT EXISTS (SELECT 1 FROM categorylinks                        #which are already empty
                WHERE cl_to = page_title)
     )
OR   (cl_to = 'Non-empty_category_redirects'                       #or cats from here
AND NOT EXISTS (SELECT 1 FROM categorylinks                        #which are already empty
                WHERE cl_to = page_title)
     )
OR   (cl_to = 'Images_from_the_Geograph_British_Isles_project_needing_categories_by_grid_square' #or cats from here
AND NOT EXISTS (SELECT 1 FROM categorylinks                        #which are already empty
                WHERE cl_to = page_title)
AND NOT EXISTS (SELECT 1 FROM categorylinks                        #and are not already listed...
                WHERE cl_from = page_id
                AND cl_to = 'Other_speedy_deletions')              #...here
#AND EXISTS (SELECT 1 FROM templatelinks                            #and are...
#            WHERE tl_from = page_id
#            AND tl_namespace = 10
#            AND tl_title = 'User:Avicennasis/emptycat')            #...tagged speedy
     )
OR    cl_to = 'Broken_category_redirects'                          #or from here precautionary
OR    cl_to = 'Cfd_requests_with_missing_discussion_page'          #or from here precautionary
    )
GROUP BY page_title;
SQL

Checking query status...
