Empty Categories @ Meta

SQL

-- SELECT cat_id, page_id, cat_title, cl_from, cl_to
SELECT page_id, cat_title, GROUP_CONCAT(cl_to SEPARATOR ', ')
FROM category
JOIN page ON cat_title = page_title
JOIN categorylinks ON page_id = cl_from
WHERE cat_pages = 0
AND cat_subcats = 0
AND cat_files = 0
AND page_is_redirect = 0
AND page_namespace = 14
AND cat_id NOT IN (
    SELECT cat_id
    FROM category
    JOIN page ON cat_title = page_title
    JOIN categorylinks ON page_id = cl_from
    WHERE cl_to = 'Maintenance_of_categories/Soft_redirected_categories'
    AND page_is_redirect = 0
    AND page_namespace = 14
)
AND cat_id NOT IN (
    SELECT cat_id
    FROM category
    JOIN page ON cat_title = page_title
    JOIN templatelinks ON page_id = tl_from
    JOIN linktarget ON tl_target_id = lt_id
    WHERE lt_title = "Do_not_delete_category"
    AND lt_namespace = 10
)
GROUP BY page_id;
SQL

Checking query status...
