insert into o
select baseshipment.managerid,

        coalesce((select sum((bsd.sendcnt-bsd.crashcnt)*bsd.bprice) from              dba.baseshipmentdet as bsd where baseshipment.shipmentid = bsd.shipmentid), 0 . 0 ) as summa,

      coalesce(sum(mainstorage.income), 0 . 0 ) as pay,

      coalesce((select sum((bsd.sendcnt-bsd.crashcnt)*(bsd.bprice-getakciz(bsd.shipmentid,bsd.commodityparty, 1 ))*pay/summa) from dba.baseshipmentdet as bsd where bsd.shipmentid = baseshipment.shipmentid), 0 . 0 ) as profitopl from
      dba.accounts,
      dba.mainstorage,
      dba.baseshipment where
      (mainstorage.corraccountid = accounts.accountid) and
      (mainstorage.invoiceid = baseshipment.shipmentid) and
      (accounts.accounttype =  9 ) and
      (accounts.branchid = @BranchID) and
      (mainstorage.datetransaction >= "date"(@atdate)) and
      (mainstorage.datetransaction < "date"(@todate)) and
      (not mainstorage.corraccountid = any(select accountid from dba.ignore_list))
      group by baseshipment.managerid,
      baseshipment.shipmentid having
      (summa <>  0 );