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

SQL

SELECT
  CASE
    p1.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('{{ns:', p1.page_namespace, '}}')
  END AS namespace,
  p1.page_title AS title,
  p1.page_is_redirect AS is_redirect,
  p1.page_is_new AS is_new,
  p1.page_len AS len,
  CONCAT(
    '[[:',
    CASE
      p1.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:', p1.page_namespace, '}}:')
    END,
    p1.page_title,
    "]]"
  ) AS pagelink
FROM
  (
    page AS p0,
    INNER JOIN categorylinks AS c ON c.cl_from = p0.page_id
    AND c.cl_type = 'page'
    AND c.cl_to = "电子游戏条目"
  )
  INNER JOIN page AS p1 ON p0.page_namespace = p1.page_namespace + 1
  AND p0.page_title = p1.page_title
SQL

Checking query status...
