未使用のカテゴリ年を含まない

SQL

SELECT
  page_title,
  page_len
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 NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to = '検索エンジンに収集されないページ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to = '追跡カテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = page_id
                AND cl_to = '隠しカテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
                WHERE tl_from = page_id
                AND lt_namespace = 10
                AND lt_title = 'Possibly_empty_category')
AND NOT EXISTS (SELECT
                  1
                FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
                WHERE tl_from = page_id
                AND lt_namespace = 10
                AND lt_title = 'Wikipedia_category');
SQL

Checking query status...
