# HG changeset patch
# User jbe
# Date 1307473002 -7200
# Node ID 368fe2299d0779925cf1c714aed165ff05947c64
# Parent  d8e11e6cfa1d8d6e6e143ee48d7aedad4795e71d
Ordering for final rank: 1st winner, 2nd initiatives fultilling direct AND indirect majority, rest ordered by schulze_rank and id

diff -r d8e11e6cfa1d -r 368fe2299d07 core.sql
--- a/core.sql	Tue Jun 07 20:42:50 2011 +0200
+++ b/core.sql	Tue Jun 07 20:56:42 2011 +0200
@@ -3805,7 +3805,11 @@
         SELECT "id"
         FROM "initiative"
         WHERE "issue_id" = "issue_id_p" AND "admitted"
-        ORDER BY "winner" DESC, "schulze_rank", "id"
+        ORDER BY
+          "winner" DESC,
+          ("direct_majority" AND "indirect_majority") DESC,
+          "schulze_rank",
+          "id"
       LOOP
         UPDATE "initiative" SET "rank" = "rank_v"
           WHERE "id" = "initiative_id_v";