X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?a=blobdiff_plain;f=yarrg%2Fweb%2Fquery_age;h=a115bbdd562dd53286be49ff175f5519f366cd28;hb=19669922dd2393c23371ee1532824e528b897de0;hp=4f8ba814b7f1e5ddf2b0ce0fc22549ad560b728d;hpb=c57d4c361a88f00f0d6dfc3bcb20f87f1d957527;p=ypp-sc-tools.db-test.git

diff --git a/yarrg/web/query_age b/yarrg/web/query_age
index 4f8ba81..a115bbd 100644
--- 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();