liquid_feedback_core
diff core.sql @ 471:124b9e7c3c23
Bugfix in view "new_updated_issue_for_notification"
author | jbe |
---|---|
date | Sun Mar 27 01:18:07 2016 +0100 (2016-03-27) |
parents | a96c920cd6a5 |
children | 0fa0d2daa54a |
line diff
1.1 --- a/core.sql Sun Mar 27 00:58:37 2016 +0100 1.2 +++ b/core.sql Sun Mar 27 01:18:07 2016 +0100 1.3 @@ -2491,7 +2491,7 @@ 1.4 LEFT JOIN "ignored_area" 1.5 ON "ignored_area"."member_id" = "member"."id" 1.6 AND "ignored_area"."area_id" = "issue"."area_id" 1.7 - LEFT JOIN 1.8 + JOIN 1.9 ( "advertised_initiative" JOIN "initiative" 1.10 ON "advertised_initiative"."initiative_id" = "initiative"."id" ) 1.11 ON "advertised_initiative"."member_id" = "member"."id" 1.12 @@ -2501,7 +2501,6 @@ 1.13 "subscription"."member_id" NOTNULL ) AND 1.14 "issue"."state" IN ('admission') AND 1.15 "interest"."member_id" ISNULL AND 1.16 - "advertised_initiative"."member_id" ISNULL 1.17 ORDER BY 1.18 "member_id", 1.19 "area_id",