Empty categories on Commons

SQL

USE commonswiki_p;
SELECT CONCAT ('# [[:Category:', page_title, ']]') AS emptycats FROM categorylinks
RIGHT JOIN page ON cl_to = page_title
WHERE page_namespace = 14
AND page_is_redirect = 0
AND cl_to IS NULL
AND page_title NOT LIKE '1%'
AND NOT EXISTS (SELECT 1 FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to = 'Category_redirects')
AND NOT EXISTS (SELECT 1 FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to = 'Disambiguation')
AND NOT EXISTS (SELECT 1 FROM templatelinks
                WHERE tl_from = page_id
                AND tl_namespace = 10
                AND tl_title = 'Empty_category')
ORDER BY page_title
LIMIT 1000
SQL

Checking query status...
