最短的極高／高重要度電子遊戲條目 (zhwiki)

SQL

SELECT
  CONCAT('[[:', REPLACE(page.page_title, "_", " "), "]]") AS 條目,
  page.page_len AS 長度

FROM
  page AS temp
  JOIN categorylinks ON (cl_to = "Top-importance physics articles" OR cl_to = "High-importance physics 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_len ASC

​x
 
SELECT  CONCAT('[[:', REPLACE(page.page_title, "_", " "), "]]") AS 條目,  page.page_len AS 長度​FROM  page AS temp  JOIN categorylinks ON (cl_to = "Top-importance physics articles" OR cl_to = "High-importance physics 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 - 1ORDER BY  page.page_len ASC

SQL

Checking query status...