From: Ian Jackson <ian@liberator.relativity.greenend.org.uk>
Date: Sat, 22 Aug 2009 14:32:27 +0000 (+0100)
Subject: Tidy up GROUP BY a bit
X-Git-Tag: 3.4~147
X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-test.git;a=commitdiff_plain;h=83d1b778c07bc89ab7142a3c46fa6698a494c164

Tidy up GROUP BY a bit
---

diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade
index e6aff44..35bec07 100644
--- a/yarrg/web/routetrade
+++ b/yarrg/web/routetrade
@@ -100,8 +100,7 @@ my $stmt= "
 	   OR	", @flow_conds)."
 	)
 	  AND	buy.price > sell.price
-	GROUP BY commodname, commods.commodid,
-		org_id, org_price, dst_id, dst_price
+	GROUP BY commods.commodid, org_id, org_price, dst_id, dst_price
 	ORDER BY org_name, dst_name, profit DESC, commodname,
 		 org_price, dst_price DESC
      ";