From 2939b280a38fa91eadac8a7bd63885cb86f584a8 Mon Sep 17 00:00:00 2001
From: Christopher Baines <mail@cbaines.net>
Date: Mon, 13 Dec 2021 15:23:42 +0000
Subject: Fix database-select-latest-recent-change-datetime

---
 nar-herder/database.scm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'nar-herder/database.scm')

diff --git a/nar-herder/database.scm b/nar-herder/database.scm
index 9cb04e2..c6daf8c 100644
--- a/nar-herder/database.scm
+++ b/nar-herder/database.scm
@@ -469,7 +469,7 @@ SELECT datetime, change, data FROM recent_changes WHERE datetime >= :datetime"
             (sqlite-prepare
              db
              "
-SELECT datetime FROM recent_changes ORDER BY datetime ASC LIMIT 1"
+SELECT datetime FROM recent_changes ORDER BY datetime DESC LIMIT 1"
              #:cache? #t)))
 
        (let ((result (match (sqlite-step statement)
-- 
cgit v1.2.3