1.1 --- a/core.sql	Tue Sep 07 21:20:18 2010 +0200
     1.2 +++ b/core.sql	Tue Oct 26 22:18:18 2010 +0200
     1.3 @@ -6,7 +6,7 @@
     1.4  BEGIN;
     1.5  
     1.6  CREATE VIEW "liquid_feedback_version" AS
     1.7 -  SELECT * FROM (VALUES ('1.2.8', 1, 2, 8))
     1.8 +  SELECT * FROM (VALUES ('1.2.9', 1, 2, 9))
     1.9    AS "subquery"("string", "major", "minor", "revision");
    1.10  
    1.11  
    1.12 @@ -2765,6 +2765,8 @@
    1.13        FOR "member_id_v" IN
    1.14          SELECT "interest"."member_id"
    1.15            FROM "interest"
    1.16 +          JOIN "member"
    1.17 +            ON "interest"."member_id" = "member"."id"
    1.18            LEFT JOIN "direct_voter"
    1.19              ON "interest"."member_id" = "direct_voter"."member_id"
    1.20              AND "interest"."issue_id" = "direct_voter"."issue_id"
    1.21 @@ -2773,10 +2775,13 @@
    1.22              AND "interest"."issue_id" = "delegating_voter"."issue_id"
    1.23            WHERE "interest"."issue_id" = "issue_id_p"
    1.24            AND "interest"."autoreject" = TRUE
    1.25 +          AND "member"."active"
    1.26            AND "direct_voter"."member_id" ISNULL
    1.27            AND "delegating_voter"."member_id" ISNULL
    1.28          UNION SELECT "membership"."member_id"
    1.29            FROM "membership"
    1.30 +          JOIN "member"
    1.31 +            ON "membership"."member_id" = "member"."id"
    1.32            LEFT JOIN "interest"
    1.33              ON "membership"."member_id" = "interest"."member_id"
    1.34              AND "interest"."issue_id" = "issue_id_p"
    1.35 @@ -2788,6 +2793,7 @@
    1.36              AND "delegating_voter"."issue_id" = "issue_id_p"
    1.37            WHERE "membership"."area_id" = "issue_row"."area_id"
    1.38            AND "membership"."autoreject" = TRUE
    1.39 +          AND "member"."active"
    1.40            AND "interest"."autoreject" ISNULL
    1.41            AND "direct_voter"."member_id" ISNULL
    1.42            AND "delegating_voter"."member_id" ISNULL