# HG changeset patch
# User jbe
# Date 1395840406 -3600
# Node ID ffc4c08cd835edf9afaa7dd0a25245399101d54b
# Parent  719ad5c5c940ae08a04929de9cdd7bfb3081a978
When marking first preferences, use JOIN via "initiative" table due to missing index on "vote"."issue_id"

diff -r 719ad5c5c940 -r ffc4c08cd835 core.sql
--- a/core.sql	Wed Mar 26 04:44:58 2014 +0100
+++ b/core.sql	Wed Mar 26 14:26:46 2014 +0100
@@ -3753,7 +3753,12 @@
               CASE WHEN "vote"."grade" = max("agg"."grade") THEN TRUE ELSE FALSE END
             ELSE NULL
             END AS "first_preference"
-          FROM "vote" JOIN "vote" AS "agg" USING ("issue_id", "member_id")
+          FROM "vote"
+          JOIN "initiative"  -- NOTE: due to missing index on issue_id
+          ON "vote"."issue_id" = "initiative"."issue_id"
+          JOIN "vote" AS "agg"
+          ON "initiative"."id" = "agg"."initiative_id"
+          AND "vote"."member_id" = "agg"."member_id"
           GROUP BY "vote"."initiative_id", "vote"."member_id"
         ) AS "subquery"
         WHERE "vote"."issue_id" = "issue_id_p"