From 83d1b778c07bc89ab7142a3c46fa6698a494c164 Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Sat, 22 Aug 2009 15:32:27 +0100 Subject: [PATCH] Tidy up GROUP BY a bit --- yarrg/web/routetrade | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) 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 "; -- 2.30.2