電子遊戲專題全部頁面 (zh)

SQL

USE zhwiki_p;
SELECT
  page.page_id AS id,
  CASE
    page.page_namespace
    WHEN 0 THEN '(Article)'
    WHEN 2 THEN 'User'
    WHEN 4 THEN 'Wikipedia'
    WHEN 6 THEN 'File'
    WHEN 8 THEN 'MediaWiki'
    WHEN 10 THEN 'Template'
    WHEN 12 THEN 'Help'
    WHEN 14 THEN 'Category'
    WHEN 100 THEN 'Portal'
    WHEN 118 THEN 'Draft'
    WHEN 828 THEN 'Module'
    ELSE CONCAT('{{ns:', page.page_namespace, '}}')
  END AS namespace,
  REPLACE(page.page_title, "_", " ") AS title,
  page.page_is_redirect AS is_redirect,
  page.page_len AS len,
  CONCAT(
    '[[:',
    CASE
      page.page_namespace
      WHEN 0 THEN ''
      WHEN 2 THEN 'User:'
      WHEN 4 THEN 'Wikipedia:'
      WHEN 6 THEN 'File:'
      WHEN 8 THEN 'MediaWiki:'
      WHEN 10 THEN 'Template:'
      WHEN 12 THEN 'Help:'
      WHEN 14 THEN 'Category:'
      WHEN 100 THEN 'Portal:'
      WHEN 118 THEN 'Draft:'
      WHEN 828 THEN 'Module:'
      ELSE CONCAT('{{subst:ns:', page.page_namespace - 1, '}}:')
    END,
    page.page_title,
    "]]"
  ) AS pagelink
FROM
  page AS temp
  JOIN categorylinks ON cl_to = "电子游戏条目"
  AND cl_type = 'page'
  AND cl_from = temp.page_id
  JOIN page ON page.page_title = temp.page_title
  AND page.page_namespace = temp.page_namespace - 1
ORDER BY
  page.page_id DESC
SQL

Checking query status...
