X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fweb%2Fquery_commod;h=ee4c9f3177aad6eb311bcb11ecb7e2b5234ca173;hb=c20deee42fbd2d86e976bb6a2e4f8e5f5cf2631b;hp=052d019f998b137cd103f806c46bbbb0f3e0fd4a;hpb=fceed60843f6a7c037b908eb529b542ad263c500;p=ypp-sc-tools.db-live.git

diff --git a/yarrg/web/query_commod b/yarrg/web/query_commod
index 052d019..ee4c9f3 100644
--- a/yarrg/web/query_commod
+++ b/yarrg/web/query_commod
@@ -97,14 +97,13 @@ foreach my $bs (split /_/, $ARGS{BuySell}) {
 	my ($ascdesc) = ($bs eq 'buy')
 		? ('DESC')
 		: ('ASC');
-	my $joinkind= $ARGS{ShowBlank} eq 'show'
-		? 'LEFT OUTER JOIN' : 'INNER JOIN';
+	my $joinkind= $ARGS{ShowBlank} ? 'LEFT OUTER JOIN' : 'INNER JOIN';
 	my $islands= $dbh->prepare(
 	"SELECT islands.islandid AS islandid, archipelago, islandname,
 			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"
 		);