- sp= stmt;
- sp += sprintf(sp,
- "SELECT\n"
- " sell.islandid src_id,\n"
- " sell.price src_price,\n"
- " sum(sell.qty) src_qty,\n"
- " buy.islandid dst_id,\n"
- " buy.price dst_price,\n"
- " sum(buy.qty) dst_qty,\n"
- " commods.commodid commodid,\n"
- " commods.unitmass unitmass,\n"
- " commods.unitvolume unitvolume,\n"
- " dist dist,\n"
- " buy.price-sell.price unitprofit\n"
- " FROM commods\n"
- " JOIN sell ON commods.commodid = sell.commodid\n"
- " JOIN buy ON commods.commodid = buy.commodid\n"
- " JOIN dists ON aiid = sell.islandid AND biid = buy.islandid\n"
- " WHERE buy.price > sell.price\n"
- " AND (");