# HG changeset patch
# User jbe
# Date 1601907497 -7200
# Node ID 8e9d0878b5dcdfba0051a93c33746f6e2297e0a0
# Parent  ae53fc96c95321a50569c024f4f6d8783b296f09
Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"

diff -r ae53fc96c953 -r 8e9d0878b5dc core.sql
--- a/core.sql	Tue Jul 28 18:57:20 2020 +0200
+++ b/core.sql	Mon Oct 05 16:18:17 2020 +0200
@@ -4174,8 +4174,8 @@
               "privilege"."member_id" = "recipient_id_p" AND
               "privilege"."unit_id" = "area"."unit_id"
             LEFT JOIN "issue_privilege" ON
-              "privilege"."member_id" = "recipient_id_p" AND
-              "privilege"."issue_id" = "initiative"."issue_id"
+              "issue_privilege"."member_id" = "recipient_id_p" AND
+              "issue_privilege"."issue_id" = "initiative"."issue_id"
             LEFT JOIN "subscription" ON
               "subscription"."member_id" = "recipient_id_p" AND
               "subscription"."unit_id" = "area"."unit_id"
diff -r ae53fc96c953 -r 8e9d0878b5dc update/core-update.v4.2.0-v4.2.1.sql
--- a/update/core-update.v4.2.0-v4.2.1.sql	Tue Jul 28 18:57:20 2020 +0200
+++ b/update/core-update.v4.2.0-v4.2.1.sql	Mon Oct 05 16:18:17 2020 +0200
@@ -184,8 +184,8 @@
               "privilege"."member_id" = "recipient_id_p" AND
               "privilege"."unit_id" = "area"."unit_id"
             LEFT JOIN "issue_privilege" ON
-              "privilege"."member_id" = "recipient_id_p" AND
-              "privilege"."issue_id" = "initiative"."issue_id"
+              "issue_privilege"."member_id" = "recipient_id_p" AND
+              "issue_privilege"."issue_id" = "initiative"."issue_id"
             LEFT JOIN "subscription" ON
               "subscription"."member_id" = "recipient_id_p" AND
               "subscription"."unit_id" = "area"."unit_id"