電子遊戲專題全部頁面 (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 p
    JOIN categorylinks ON cl_from = p.page_id
    AND cl_type = 'page'
    JOIN page ON page.page_title = p.page_title
    AND page.page_namespace = p.page_namespace - 1
WHERE
    cl_to = "电子游戏条目"
ORDER BY
    page.page_id DESC
SQL

Checking query status...
