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 AS temp
  JOIN categorylinks AS cl1 ON cl1.cl_to = '电子游戏条目'
  AND cl1.cl_type = 'page'
  AND cl1.cl_from = temp.page_id 
  JOIN categorylinks AS cl2 ON cl2.cl_to = '虚构角色条目'
  AND cl2.cl_type = 'page'
  AND cl2.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
ORDER BY
  page.page_id ASC
SQL

Checking query status...
