From ee80b1ab92305277d07d99faea8682aea690b59a Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Sun, 23 Aug 2009 22:23:20 +0100 Subject: [PATCH] fix spurious comma causing syntax error in query --- yarrg/web/query_commod | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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" ); -- 2.30.2