1.1 --- a/core.sql	Sun May 29 20:13:37 2011 +0200
     1.2 +++ b/core.sql	Sun May 29 20:44:07 2011 +0200
     1.3 @@ -3834,10 +3834,7 @@
     1.4           UPDATE "initiative" SET "disqualified" = TRUE
     1.5            FROM (
     1.6              SELECT "losing_initiative"."id" AS "initiative_id"
     1.7 -            FROM "issue"
     1.8 -            JOIN "initiative" "losing_initiative"
     1.9 -              ON "losing_initiative"."issue_id" = "issue_id_p"
    1.10 -              AND "losing_initiative"."admitted"
    1.11 +            FROM "initiative" "losing_initiative"
    1.12              JOIN "battle_participant" "winning_participant"
    1.13                ON "winning_participant"."issue_id" = "issue_id_p"
    1.14              LEFT JOIN "initiative" "winning_initiative"
    1.15 @@ -3859,7 +3856,8 @@
    1.16                  ( "battle_lose"."losing_initiative_id" ISNULL AND
    1.17                    "winning_initiative"."id" ISNULL ) )
    1.18                AND "battle_lose"."winning_initiative_id" = "losing_initiative"."id"
    1.19 -            WHERE "issue"."id" = "issue_id_p"
    1.20 +            WHERE "losing_initiative"."issue_id" = "issue_id_p"
    1.21 +            AND "losing_initiative"."admitted"
    1.22              AND (
    1.23                ("winning_initiative"."id" ISNULL AND "losing_initiative"."unfavored") OR
    1.24                ( "winning_initiative"."preliminary_rank" <