Untitled query #60611

SQL

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 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
FROM
  page AS temp
  JOIN categorylinks ON cl_to = "GA-Class_video_game_articles"
  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...
