This particular code doesn't work, but is it possible to do something similar?
SELECT *
FROM `order`
ORDER BY `order`.`year` ASC
ORDER BY `order`.`month` ASC
ORDER BY `order`.`day` ASC
LIMIT 0 , 10
Basically order lots of posts from oldest to newest.
