Tidy up GROUP BY a bit

diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade
index e6aff44eece5329da0bccc817e641ac7597f7d92..35bec07ad827d5cf2cb62f0482f3e4d8ea513bf5 100644 (file)
--- 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
      ";