summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xmat2
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) {