# HG changeset patch
# User jbe
# Date 1306694647 -7200
# Node ID f21a0b10f8ed839aef9fa644f95c62c6b0c4ed82
# Parent  c6a47e32b2fb6e548b04a0cb464f2d5ed644d25c
Removed unneccessary JOIN in function "calculate_ranks"

diff -r c6a47e32b2fb -r f21a0b10f8ed core.sql
--- a/core.sql	Sun May 29 20:13:37 2011 +0200
+++ b/core.sql	Sun May 29 20:44:07 2011 +0200
@@ -3834,10 +3834,7 @@
          UPDATE "initiative" SET "disqualified" = TRUE
           FROM (
             SELECT "losing_initiative"."id" AS "initiative_id"
-            FROM "issue"
-            JOIN "initiative" "losing_initiative"
-              ON "losing_initiative"."issue_id" = "issue_id_p"
-              AND "losing_initiative"."admitted"
+            FROM "initiative" "losing_initiative"
             JOIN "battle_participant" "winning_participant"
               ON "winning_participant"."issue_id" = "issue_id_p"
             LEFT JOIN "initiative" "winning_initiative"
@@ -3859,7 +3856,8 @@
                 ( "battle_lose"."losing_initiative_id" ISNULL AND
                   "winning_initiative"."id" ISNULL ) )
               AND "battle_lose"."winning_initiative_id" = "losing_initiative"."id"
-            WHERE "issue"."id" = "issue_id_p"
+            WHERE "losing_initiative"."issue_id" = "issue_id_p"
+            AND "losing_initiative"."admitted"
             AND (
               ("winning_initiative"."id" ISNULL AND "losing_initiative"."unfavored") OR
               ( "winning_initiative"."preliminary_rank" <