1 files changed, 4 insertions, 1 deletions
diff --git a/mat b/mat
index dcf9ca1..6de3bd7 100755
--- a/mat
+++ b/mat
@@ -409,7 +409,10 @@ sub cmd_shoppinglist {
 #  }
 
   my $entries = $db->selectall_arrayref("SELECT recipe_id FROM plan WHERE date ".
-      "BETWEEN '".$startdate."' and '".$enddate."'", { Slice => {} });
+      "BETWEEN '".$startdate."' and '".$enddate."' and ".
+      "IFNULL(state, 'null') != 'frozen' and ".
+      "IFNULL(state, 'null') != 'ready' and ".
+      "IFNULL(state, 'null') != 'sourced'", { Slice => {} });
   my %recipe_count;
   for my $entry ( @$entries ) {
      $recipe_count{$entry->{recipe_id}}++;