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

SQL

SELECT
  P.page_title,
  P.page_id
FROM categorylinks
RIGHT JOIN page P ON cl_to = P.page_title
WHERE P.page_namespace = 14
AND P.page_is_redirect = 0
AND cl_to IS NULL
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to = '検索エンジンに収集されないページ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to = '追跡カテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to = '隠しカテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to = 'テンプレートによって追加されるカテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to = '統合提案中のカテゴリ')
AND NOT EXISTS (SELECT
                  1
                FROM categorylinks
                WHERE cl_from = P.page_id
                AND cl_to LIKE '未使用のカテゴリ%')
AND NOT EXISTS (SELECT
                  1
                FROM templatelinks JOIN linktarget ON tl_target_id = lt_id
                WHERE tl_from = P.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 = P.page_id
                AND lt_namespace = 10
                AND lt_title = '画像提供案内')
AND P.page_title NOT LIKE 'User%'
AND P.page_title NOT LIKE '%ウィキペディアン'
AND P.page_title NOT LIKE '井戸端の話題%'
AND P.page_title LIKE '%年%';
SQL

Checking query status...
