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

SQL

SELECT
  P.page_title AS '名称',
  H.rev_timestamp AS '作成日',
  A.actor_name AS '初版作成者'
FROM categorylinks
RIGHT JOIN page P ON cl_to = P.page_title
INNER JOIN revision H ON P.page_id = H.rev_page
INNER JOIN actor A ON H.rev_actor = A.actor_id
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 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 = 'Wikipedia_category');
SQL

Checking query status...
