Empty categories on Commons

SQL

USE commonswiki_p;
SELECT CONCAT('# [[:Category:', REPLACE(page_title,'_',' '), ']]') AS emptycats FROM categorylinks
RIGHT JOIN page ON cl_to = page_title
WHERE page_namespace = 14
AND page_is_redirect = 0
AND page_is_new = 0
AND cl_to IS NULL
AND page_title NOT REGEXP '^(Commons\:|Collection_of_The_New_Art_Gallery_Walsall|Collection_of_West_Midlands_Police_Museum|IMO_|Images_from_Wiki_Loves_)'
AND page_title NOT REGEXP '(FOP_cases|requiring_review|to_be_classified|unidentified)'
AND page_title NOT REGEXP '^[0-9]{2}'
AND page_title NOT REGEXP '^(January|February|March|April|May|June|July|August|September|October|November|December)_'
AND ((page_len = 0) OR (DATEDIFF(CURRENT_TIMESTAMP, (SELECT MAX(rev_timestamp) FROM revision WHERE rev_page = page_id)) > 56))
AND NOT EXISTS (SELECT 1 FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to IN ('Categories_with_authority_control_data',
                              'Category_redirects',
                              'Commons_maintenance_content',
                              'Disambiguation',
                              'Images_for_cleanup',
                              'No_more_recognized_taxon',
                              'NoUploads',
                              'Taxon_categories'))
AND NOT EXISTS (SELECT 1 FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to REGEXP '^(Cultural_heritage_|GLAM_|Protected_areas?_|User_categories)')
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title IN ('CatDevelop',
                                 'Category_for_discussion',
                                 'Empty_category',
                                 'Emptycat',
                                 'EmptyCatGood',
                                 'Fotothek_category_header',
                                 'Global_maintenance_category',
                                 'Local_maintenance_category'))
AND NOT EXISTS (SELECT 1 FROM revision WHERE rev_page = page_id AND rev_user = 133084)
ORDER BY page_title
LIMIT 1000;
SQL

Checking query status...
