电子游戏条目使用但未标记专题横幅的文件

SQL

WITH pages_vg AS (
  WITH pages_vg_talk AS (
    SELECT
      page.page_namespace,
      page.page_title
    FROM
      page
      JOIN categorylinks ON cl_to IN (
        '极高重要度电子游戏条目',
        '高重要度电子游戏条目',
        '中重要度电子游戏条目',
        '低重要度电子游戏条目',
        '未知重要度电子游戏条目'
      )
      AND cl_type = 'page'
      AND cl_from = page.page_id
  )
  SELECT
    page.page_id
  FROM
    page
    JOIN pages_vg_talk ON page.page_title = pages_vg_talk.page_title
    AND page.page_namespace + 1 = pages_vg_talk.page_namespace
),
files_vg_title AS (
  SELECT
    DISTINCT imagelinks.il_to
  FROM
    pages_vg
    JOIN imagelinks ON il_from = pages_vg.page_id
    JOIN page ON (
      imagelinks.il_to = page.page_title
      AND page.page_namespace = 6
    )
  WHERE
    page.page_title IS NOT NULL
),
file_vg_talk_page AS (
  SELECT
    files_vg_title.il_to,
    page.page_id
  FROM
    files_vg_title
    JOIN page ON files_vg_title.il_to = page.page_title
    AND page.page_namespace = 7
)
SELECT
  *
FROM
  file_vg_talk_page
  JOIN categorylinks ON categorylinks.cl_to = '文件级电子游戏条目'
  AND categorylinks.cl_type = 'page'
  AND categorylinks.cl_from = file_vg_talk_page.page_id
SQL

Checking query status...
