Categories to be touched on Commons

SQL

USE commonswiki_p;
SELECT CONCAT ('[[Category:', 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')
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 = 'Broken_category_redirects'                          #or from here
OR    cl_to = 'Cfd_requests_with_missing_discussion_page'          #or here
    )
ORDER BY page_title;
SQL

Checking query status...
