commit 08ab8233e2dcae790f8bb5244a2ea8e5ab4af2bb
Author: Matt Williams <matt@miliams.com>
Date:   Tue Mar 31 17:09:58 2009 +0100

    Order items by priority on the roadmap page.
    It now sorts by status, then priority then by last_updated
    
    Signed-off-by: Matt Williams <matt@miliams.com>

diff --git a/roadmap_page.php b/roadmap_page.php
index 3b82400..979a6e7 100644
--- a/roadmap_page.php
+++ b/roadmap_page.php
@@ -168,7 +168,7 @@
 			$query = "SELECT sbt.*, $t_relation_table.source_bug_id, dbt.target_version as parent_version FROM $t_bug_table AS sbt
 						LEFT JOIN $t_relation_table ON sbt.id=$t_relation_table.destination_bug_id AND $t_relation_table.relationship_type=2
 						LEFT JOIN $t_bug_table AS dbt ON dbt.id=$t_relation_table.source_bug_id
-						WHERE sbt.project_id=" . db_param() . " AND sbt.target_version=" . db_param() . " ORDER BY sbt.status ASC, sbt.last_updated DESC";
+						WHERE sbt.project_id=" . db_param() . " AND sbt.target_version=" . db_param() . " ORDER BY sbt.status ASC, sbt.priority DESC, sbt.last_updated DESC";
 
 			$t_description = $t_version_row['description'];