X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fweb%2Fquery_commod;fp=yarrg%2Fweb%2Fquery_commod;h=ee4c9f3177aad6eb311bcb11ecb7e2b5234ca173;hb=ee80b1ab92305277d07d99faea8682aea690b59a;hp=0bd36cbffa4db9e958ce30cbc84521a181e70862;hpb=ae2261626c616614c25c26604f66627247206861;p=ypp-sc-tools.web-live.git

diff --git a/yarrg/web/query_commod b/yarrg/web/query_commod
index 0bd36cb..ee4c9f3 100644
--- a/yarrg/web/query_commod
+++ b/yarrg/web/query_commod
@@ -103,7 +103,7 @@ foreach my $bs (split /_/, $ARGS{BuySell}) {
 			sum(qty) as tqty
 		FROM islands $joinkind $bs offers
 		ON islands.islandid == offers.islandid AND commodid == ?
-		GROUP BY islands.islandid,
+		GROUP BY islands.islandid
 		ORDER BY archipelago, islandname"
 		);