Empty categories on Commons

SQL

USE stopcommonswiki_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_|^FoP\-|FOP_cases|^IMO_|^Images_from_Wiki_Loves_|requiring_review|to_be_classified|unidentified)'
AND page_title NOT REGEXP '^([0-9]{2}|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 REGEXP '^(Categories_with_authority_control_data|Category_redirects|Commons_maintenance_content|Cultural_heritage_|Disambiguation|GLAM_|Images_for_cleanup|No_more_recognized_taxon|NoUploads|Protected_areas?_|Taxon_categories|User_categories)')
AND NOT EXISTS (SELECT 1 FROM templatelinks
    WHERE tl_from = page_id
    AND tl_namespace = 10
    AND tl_title REGEXP '^(CatDevelop|Category_for_discussion|Empty_category|Emptycat|EmptyCatGood|Fotothek_category_header|Global_maintenance_category|Local_maintenance_category|NoFoP)')
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...
