Sandbox - Quarry

SQL

SELECT   page.page_id AS id,
  page.page_title AS page_title,
  page.page_len AS len,
  page.page_latest AS latest_oldid
FROM page   JOIN categorylinks AS cl2 ON cl2.cl_to = '電子遊戲系列'
  AND cl2.cl_type = 'page'
  AND cl2.cl_from = temp.page_id 
  JOIN page2 as 

(SELECT
  page.page_id AS id
FROM
  page AS temp
  JOIN categorylinks AS cl1 ON cl1.cl_to = '电子游戏条目'
  AND cl1.cl_type = 'page'
  AND cl1.cl_from = temp.page_id 

  JOIN page ON page.page_title = temp.page_title
  AND temp.page_namespace = 1
  AND page.page_namespace = temp.page_namespace - 1
)
 on page.page_id = page2.id

  
  
ORDER BY
  page.page_id ASC
SQL

Checking query status...
