Sandbox - Quarry

SQL

WITH vg_talk_pages AS(
  SELECT
    *
  FROM
    page
    JOIN categorylinks ON cl_to = '电子游戏条目'
    AND cl_type = 'page'
    AND cl_from = page.page_id
),
vg_pages AS (
  SELECT
    page.*
  FROM
    page
    JOIN vg_talk_pages ON page.page_title = vg_talk_pages.page_title
    AND page.page_namespace = vg_talk_pages.page_namespace - 1
)
SELECT
  vg_pages.page_id AS id,
  vg_pages.page_title AS page_title,
  vg_pages.page_len AS len,
  vg_pages.page_latest AS latest_oldid
FROM
  vg_pages
  JOIN categorylinks ON cl_to = '電子遊戲系列'
  AND cl_type = 'page'
  AND cl_from = page.page_id
SQL

Checking query status...
