X-Git-Url: http://www.chiark.greenend.org.uk/ucgi/~yarrgweb/git?p=ypp-sc-tools.db-live.git;a=blobdiff_plain;f=yarrg%2Fweb%2Froutetrade;h=d152eed6a0f6485456340deb404546fcc4cb0620;hp=2438059a170cb1bf124dfd7fffe91b9b98c45f37;hb=ae2261626c616614c25c26604f66627247206861;hpb=e9609637b8acfaf47a176e6d0c934d1f907e27a8

diff --git a/yarrg/web/routetrade b/yarrg/web/routetrade
index 2438059..d152eed 100644
--- a/yarrg/web/routetrade
+++ b/yarrg/web/routetrade
@@ -140,15 +140,15 @@ my $stmt= "
 		dist						dist,
 		buy.price - sell.price				unitprofit
 	FROM commods
-	JOIN buy  on commods.commodid = buy.commodid
-	JOIN sell on commods.commodid = sell.commodid
-	JOIN islands as sell_islands on sell.islandid = sell_islands.islandid
-	JOIN islands as buy_islands  on buy.islandid  = buy_islands.islandid
+	JOIN buy  ON commods.commodid = buy.commodid
+	JOIN sell ON commods.commodid = sell.commodid
+	JOIN islands AS sell_islands ON sell.islandid = sell_islands.islandid
+	JOIN islands AS buy_islands  ON buy.islandid  = buy_islands.islandid
 ".($qa->{ShowStalls} ? "
-	JOIN stalls  as sell_stalls  on sell.stallid  = sell_stalls.stallid
-	JOIN stalls  as buy_stalls   on buy.stallid   = buy_stalls.stallid
+	JOIN stalls  AS sell_stalls  ON sell.stallid  = sell_stalls.stallid
+	JOIN stalls  AS buy_stalls   ON buy.stallid   = buy_stalls.stallid
 " : "")."
-	JOIN dists on aiid = sell.islandid AND biid = buy.islandid
+	JOIN dists ON aiid = sell.islandid AND biid = buy.islandid
 	WHERE	(
 		".join("
 	   OR	", @flow_conds)."