電子遊戲專題全部頁面 (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 102 THEN 'WikiProject'
    WHEN 118 THEN 'Draft'
    WHEN 828 THEN 'Module'
    ELSE CONCAT('{{ns:', page.page_namespace, '}}')
  END AS namespace,
  REPLACE(page.page_title, "_", " ") AS page_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 102 THEN 'WikiProject:'
      WHEN 118 THEN 'Draft:'
      WHEN 828 THEN 'Module:'
      ELSE CONCAT('{{subst:ns:', page.page_namespace - 1, '}}:')
    END,
    page.page_title,
    "]]"
  ) AS pagelink,
  revision.rev_timestamp AS last_edited,
  actor.actor_name AS last_edited_by
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
  JOIN revision ON temp.page_id = revision.rev_id
  JOIN actor ON revision.rev_actor = actor.actor_name
ORDER BY
  page.page_id DESC
SQL

Checking query status...
