From 32ee786c56ff8ab51ffe68e9d5bdb329509b0cf1 Mon Sep 17 00:00:00 2001
From: Sergey Matveev <stargrave@stargrave.org>
Date: Sun, 22 Dec 2019 15:10:34 +0300
Subject: [PATCH] Order by datetime

---
 pem | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/pem b/pem
index 6127363..29392ec 100755
--- a/pem
+++ b/pem
@@ -55,7 +55,8 @@ s)
         FROM expenses
         LEFT JOIN m2m ON m2m.expense_id=expenses.id
         LEFT JOIN tags ON m2m.tag_id=tags.id
-        GROUP BY expenses.id"
+        GROUP BY expenses.id
+        ORDER BY dt DESC"
     ;;
 t)
     $SQLITE -column -header $DB "
-- 
2.44.0