长期未编辑的电子游戏专题条目 (zhwiki)

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_title
    page.page_id,
    page.page_latest
  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
)
SELECT
  page.page_title, revision.rev_timestamp
FROM
  pages_vg JOIN revision ON pages_vg.page_latest = revision.rev_id
ORDER BY
  revision.rev_id ASC,
  pages_vg.page_title ASC
SQL

Checking query status...
