X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;ds=sidebyside;f=yarrg%2Fweb%2Fquery_commod;fp=yarrg%2Fweb%2Fquery_commod;h=c801a631e65855d4e762aa247bb702bf883ecfc1;hb=19669922dd2393c23371ee1532824e528b897de0;hp=8d55f2686130568ba92d2c578dd787d2362e368e;hpb=c57d4c361a88f00f0d6dfc3bcb20f87f1d957527;p=ypp-sc-tools.main.git

diff --git a/yarrg/web/query_commod b/yarrg/web/query_commod
index 8d55f26..c801a63 100644
--- a/yarrg/web/query_commod
+++ b/yarrg/web/query_commod
@@ -99,7 +99,7 @@ foreach my $bs (split /_/, $ARGS{BuySell}) {
 
 	my $offers= $dbh->prepare(
 	"SELECT stallname, price, qty
-		FROM $bs NATURAL JOIN stalls
+		FROM $bs JOIN stalls USING (stallid, islandid)
 		WHERE commodid = ? AND islandid = ?
 		ORDER BY price $ascdesc"
 		);