chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-live.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
yarrg: fanchuans
[ypp-sc-tools.db-live.git]
/
yarrg
/
web
/
query_commod
diff --git
a/yarrg/web/query_commod
b/yarrg/web/query_commod
index 8d55f2686130568ba92d2c578dd787d2362e368e..c801a631e65855d4e762aa247bb702bf883ecfc1 100644
(file)
--- 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"
);