USE zh_classicalwiki_p;

​

SELECT 

    `a`.`ar_title`,

    `a`.`min_timestamp`

FROM

    (SELECT 

        `a`.`ar_title`, `a`.`min_timestamp`

    FROM

        (SELECT DISTINCT

        `ar_title`

    FROM

        `archive`) AS `archive`

    INNER JOIN (SELECT 

        `a`.`ar_title`, MIN(`a`.`ar_timestamp`) AS `min_timestamp`

    FROM

        `archive` AS `a`

    WHERE `a`.`ar_namespace` = 0

    GROUP BY `a`.`ar_title`) AS `a` ON `archive`.`ar_title` = `a`.`ar_title`) AS `a`

ORDER BY `a`.`min_timestamp` ASC

;