文言維基條目順序

SQL

USE zh_classicalwiki_p;

SELECT 
    `page`.`page_title`,
    `r`.`min_timestamp`
FROM
    (SELECT 
        `r`.`rev_page`, `r`.`min_timestamp`
    FROM
        (SELECT DISTINCT
        `rev_page`
    FROM
        `revision`) AS `revision`
    INNER JOIN (SELECT 
        `r`.`rev_page`, MIN(`r`.`rev_timestamp`) AS `min_timestamp`
    FROM
        `revision` AS `r`
    GROUP BY `r`.`rev_page`) AS `r` ON `revision`.`rev_page` = `r`.`rev_page`) AS `r`
        INNER JOIN
    `page` ON `page`.`page_namespace` = 0
        AND `page`.`page_is_redirect` = 0
        AND `page`.`page_id` = `r`.`rev_page`
ORDER BY `r`.`min_timestamp` ASC
;
SQL

Checking query status...
