Order inventory by preparation date.

1 files changed, 1 insertions, 1 deletions

diff --git a/mat b/mat
index 45ce51d..8e86cc2 100755
--- a/mat
+++ b/mat
@@ -185,7 +185,7 @@ sub cmd_inventory {
 
   my $sql = "SELECT recipe_id, count(recipe_id), storage FROM inventory";
   $sql .= " WHERE storage='$storage'" if ( $storage );
-  $sql .= " GROUP BY storage, recipe_id";
+  $sql .= " GROUP BY storage, preparation_date, recipe_id";
 
   my $all = $db->selectall_arrayref($sql);
   foreach my $row (@$all) {