my $islands= $dbh->prepare(
"SELECT islands.islandid AS islandid, archipelago, islandname,
sum(qty) as tqty
FROM islands $joinkind $bs offers
ON islands.islandid == offers.islandid AND commodid == ?
my $islands= $dbh->prepare(
"SELECT islands.islandid AS islandid, archipelago, islandname,
sum(qty) as tqty
FROM islands $joinkind $bs offers
ON islands.islandid == offers.islandid AND commodid == ?