X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.main.git;a=blobdiff_plain;f=yarrg%2Fweb%2Fquery_commod;h=0bd36cbffa4db9e958ce30cbc84521a181e70862;hp=052d019f998b137cd103f806c46bbbb0f3e0fd4a;hb=2007f48bd68be9218b8f41acd9ba32d378a1b22c;hpb=b54e4d479114f7641bddf8a47d075639323620d2

diff --git a/yarrg/web/query_commod b/yarrg/web/query_commod
index 052d019..0bd36cb 100644
--- a/yarrg/web/query_commod
+++ b/yarrg/web/query_commod
@@ -97,8 +97,7 @@ 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