# HG changeset patch
# User jbe
# Date 1459037887 -3600
# Node ID 124b9e7c3c2336e75319d20f2408ad296898b02d
# Parent  a96c920cd6a5b7e2cead2983c21b8b048634c5e2
Bugfix in view "new_updated_issue_for_notification"

diff -r a96c920cd6a5 -r 124b9e7c3c23 core.sql
--- a/core.sql	Sun Mar 27 00:58:37 2016 +0100
+++ b/core.sql	Sun Mar 27 01:18:07 2016 +0100
@@ -2491,7 +2491,7 @@
     LEFT JOIN "ignored_area"
       ON "ignored_area"."member_id" = "member"."id"
       AND "ignored_area"."area_id" = "issue"."area_id"
-    LEFT JOIN
+    JOIN
       ( "advertised_initiative" JOIN "initiative"
         ON "advertised_initiative"."initiative_id" = "initiative"."id" )
       ON "advertised_initiative"."member_id" = "member"."id"
@@ -2501,7 +2501,6 @@
         "subscription"."member_id" NOTNULL ) AND
       "issue"."state" IN ('admission') AND
       "interest"."member_id" ISNULL AND
-      "advertised_initiative"."member_id" ISNULL
     ORDER BY
       "member_id",
       "area_id",