liquid_feedback_core

changeset 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
files core.sql
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",

Impressum / About Us