liquid_feedback_core
changeset 141:f21a0b10f8ed
Removed unneccessary JOIN in function "calculate_ranks"
author | jbe |
---|---|
date | Sun May 29 20:44:07 2011 +0200 (2011-05-29) |
parents | c6a47e32b2fb |
children | 54ac8c473263 |
files | core.sql |
line diff
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" <