X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.main.git;a=blobdiff_plain;f=yarrg%2Fweb%2Froutetrade;h=c62ca60b7f89a7956008cacc7c8998ae944a72c7;hp=03ef3e1e8dc4ab99bfc8b29cfc8b69750268845c;hb=19669922dd2393c23371ee1532824e528b897de0;hpb=55b97973486c7568b36c89aa4b16e2d5b42f0614

diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade
index 03ef3e1..c62ca60 100644
--- a/yarrg/web/routetrade
+++ b/yarrg/web/routetrade
@@ -1010,12 +1010,12 @@ END
 <%perl>
 	my $sth_i= $dbh->prepare(<<END);
 		SELECT archipelago, islandid, islandname, timestamp
-			FROM uploads NATURAL JOIN islands
+			FROM uploads JOIN islands USING (islandid)
 			WHERE islandid = ?
 END
 	my $sth_a= $dbh->prepare(<<END);
 		SELECT archipelago, islandid, islandname, timestamp
-			FROM uploads NATURAL JOIN islands
+			FROM uploads JOIN islands USING (islandid)
 			WHERE archipelago = ?
 			ORDER BY islandname
 END