Sort results by date

1 files changed, 1 insertions, 1 deletions

diff --git a/src/clog.c b/src/clog.c
index 4c5f0c2..d3fa324 100644
--- a/src/clog.c
+++ b/src/clog.c
@@ -68,7 +68,7 @@ page(struct http_request *req)
 	err = kore_pgsql_query(
 		&sql,
 		"SELECT id, title, created_at::DATE, body FROM posts "
-		"ORDER BY id ASC;"
+		"ORDER BY updated_at DESC;"
 	);
 	if (!err) {
 		kore_pgsql_logerror(&sql);