1.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Mon Apr 04 23:55:22 2016 +0200
     1.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Tue Apr 05 00:19:33 2016 +0200
     1.3 @@ -100,6 +100,7 @@
     1.4      "ignored_initiative"."member_id" = "supporter"."member_id" AND
     1.5      "ignored_initiative"."initiative_id" = "supporter"."initiative_id"
     1.6    WHERE "issue"."state" IN ('admission', 'discussion')
     1.7 +  AND "initiative"."revoked" ISNULL
     1.8    AND "ignored_initiative"."member_id" ISNULL
     1.9    AND (
    1.10      EXISTS (
    1.11 @@ -185,6 +186,7 @@
    1.12              WHERE "supporter"."member_id" = "member_id_v"
    1.13              AND "issue"."area_id" = "area_id_p"
    1.14              AND "issue"."state" IN ('admission', 'discussion', 'verification')
    1.15 +            AND "initiative"."revoked" ISNULL
    1.16              AND "self_support"."member_id" ISNULL
    1.17              AND NOT "initiative_id_ary" @> ARRAY["initiative"."id"]
    1.18              AND (
    1.19 @@ -253,6 +255,7 @@
    1.20        "uf_initiative_full"."id" = "uf_initiative"."initiative_id"
    1.21      JOIN "initiative" ON
    1.22        "initiative"."issue_id" = "uf_initiative_full"."issue_id"
    1.23 +    WHERE "initiative"."revoked" ISNULL
    1.24      ORDER BY
    1.25        "uf_initiative"."recipient_id",
    1.26        "initiative"."issue_id",