diff options
-rwxr-xr-x | mat | 2 |
1 files changed, 1 insertions, 1 deletions
@@ -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) { |