From ae2261626c616614c25c26604f66627247206861 Mon Sep 17 00:00:00 2001 From: Ian Jackson Date: Sun, 23 Aug 2009 21:51:25 +0100 Subject: [PATCH] Capitalise some keywords --- yarrg/web/routetrade | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) 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)." -- 2.30.2