chiark
/
gitweb
/
~yarrgweb
/
ypp-sc-tools.db-test.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
| inline |
side by side
yarrg database code: eliminate all NATURAL JOINs and turn them into JOIN USING
[ypp-sc-tools.db-test.git]
/
yarrg
/
web
/
query_age
diff --git
a/yarrg/web/query_age
b/yarrg/web/query_age
index 4f8ba814b7f1e5ddf2b0ce0fc22549ad560b728d..a115bbdd562dd53286be49ff175f5519f366cd28 100644
(file)
--- a/
yarrg/web/query_age
+++ b/
yarrg/web/query_age
@@
-47,7
+47,7
@@
$dbh
my $now= time;
my $sth= $dbh->prepare("SELECT archipelago, islandid, islandname, timestamp
- FROM uploads
NATURAL JOIN islands
+ FROM uploads
JOIN islands USING (islandid)
ORDER BY archipelago, islandname");
$sth->execute();