Empty Categories @ Meta

SQL

SELECT cat_id, page_id, cat_title, page_namespace
FROM category
JOIN page ON cat_title = page_title
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 categorylinks ON cat_id = cl_from
    -- this does not work. but why?
    -- WHERE cl_to = 'Maintenance_of_categories/Soft_redirected_categories'
    WHERE cl_to LIKE '%Soft_redirects%'
)
*/
;

/*
    SELECT cat_id, cat_title, cl_from, cl_to
    FROM category
    JOIN categorylinks ON cat_id = cl_from
    WHERE cl_to LIKE '%Soft%';
*/
/*
    SELECT cat_id, cat_title, cl_from, cl_to
    FROM category
    JOIN categorylinks ON cat_id = cl_from
    LIMIT 10;
*/
SQL

Checking query status...
