#!/bin/sh -e
# pem -- GNU Personal Expenses Manager inspired simpler script
-# Copyright (C) 2015 Sergey Matveev (stargrave@stargrave.org)
+# Copyright (C) 2015-2021 Sergey Matveev (stargrave@stargrave.org)
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
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 "