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

;

​