# HG changeset patch
# User jbe
# Date 1459693598 -7200
# Node ID 14bca0b5692505acaf9503842da0450d25b9dc60
# Parent  9aa403a05261282789a62855330189b18bd0adfa
Ignore suggestions with opinion

diff -r 9aa403a05261 -r 14bca0b56925 core.sql
--- a/core.sql	Sat Apr 02 22:08:39 2016 +0200
+++ b/core.sql	Sun Apr 03 16:26:38 2016 +0200
@@ -2425,7 +2425,11 @@
       AND "draft"."id" > "supporter"."draft_id"
     ) OR EXISTS (
       SELECT NULL FROM "suggestion"
+      LEFT JOIN "opinion" ON
+        "opinion"."member_id" = "supporter"."member_id" AND
+        "opinion"."suggestion_id" = "suggestion"."id"
       WHERE "suggestion"."initiative_id" = "initiative"."id"
+      AND "opinion"."member_id" ISNULL
       AND COALESCE(
         "suggestion"."id" > "sent"."last_suggestion_id",
         TRUE