chiark / gitweb /
Tidy up GROUP BY a bit
authorIan Jackson <ian@liberator.relativity.greenend.org.uk>
Sat, 22 Aug 2009 14:32:27 +0000 (15:32 +0100)
committerIan Jackson <ian@liberator.relativity.greenend.org.uk>
Sat, 22 Aug 2009 14:32:27 +0000 (15:32 +0100)
yarrg/web/routetrade

index e6aff44..35bec07 100644 (file)
@@ -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
      ";