- "SELECT islandid, archipelago, islandname, sum(qty) as tqty
- FROM $bs NATURAL JOIN islands
- WHERE commodid = ?
- GROUP BY islandid,
+ "SELECT islands.islandid AS islandid, archipelago, islandname,
+ sum(qty) as tqty
+ FROM islands LEFT OUTER JOIN $bs offers
+ ON islands.islandid == offers.islandid AND commodid == ?
+ GROUP BY islands.islandid,