sum(case when instruction:accounts[0] IN ('8Hr93jyQUiZfa4CQQiJ48CAZbotcUYWPMBVzzYb49nss')

AND instruction:accounts[3] = 'BNTH5DWDPWsHsSQVscqJVe2GQKnQcAmPt4BLRPMGPfHu'

AND instruction:accounts[11] = value:parsed:info:destination

then value:parsed:info:amount

end) as MUD_SDU

,sum(case when instruction:accounts[0] IN ('5LVVJEAYEQPMoKp45r7GfNcnNDro1oFDgnLo7XHha3Xp')

AND instruction:accounts[3] = 'BNTH5DWDPWsHsSQVscqJVe2GQKnQcAmPt4BLRPMGPfHu'

AND instruction:accounts[11] = value:parsed:info:destination

then value:parsed:info:amount

end) as ONI_SDU

,sum(case when instruction:accounts[0] IN ('94LdKdSHuG3Na6H1YhkgJsq1caYVxUNeBRm7rLB6hd8k')

AND instruction:accounts[3] = 'BNTH5DWDPWsHsSQVscqJVe2GQKnQcAmPt4BLRPMGPfHu'

AND instruction:accounts[11] = value:parsed:info:destination

then value:parsed:info:amount

end) as UST_SDU

--,sum(case when instruction:accounts[3] IN ('3AGhSz9HkLFtq8DgEriso3st5yDExgA3hGLaXLCMfYmo', 'qCPVfiXJZdJEgK4eQPezMDyvMRQ5hvbcsb4VKk8ov5N', '6zA7A1d7bQ1g6yoCAEjC3UqZDPCY5vNasmSRGK7JY5Zw') then value:parsed:info:amount ELSE 0 end) as FBLBPL_in,

FROM solana.core.fact_events

, lateral flatten(input => inner_instruction:instructions)

WHERE program_id IN ('SAGE2HAwep459SNq61LHvjxPk4pLPEJLoMETef7f7EE')

AND succeeded = 'true'

AND instruction:accounts[4] = 'CSTatsVpHbvZmwHbCjZKVfYQT5JXfsXccXufhEcwCqTg'

AND instruction:accounts[8] = 'GAMEzqJehF8yAnKiTARUuhZMvLvkZVAsCVri5vSfemLr'

AND instruction:accounts[12] = 'Cargo2VNTPPTi9c1vq1Jw5d3BWUNr18MjRtSupAghKEk'

--AND tx_id = '59gAsC5DMxKtsvoqiHXKC4ELSeZJxzD3qxmNvu21nA8KeAvn7TA5mFR3Z7bL2xxQzuuE2px9U4fZie3kWxwgx4CF'

--AND value:parsed:info:authority = signers[0]::string

--AND instruction:accounts[3] IN ('3AGhSz9HkLFtq8DgEriso3st5yDExgA3hGLaXLCMfYmo', 'qCPVfiXJZdJEgK4eQPezMDyvMRQ5hvbcsb4VKk8ov5N', '6zA7A1d7bQ1g6yoCAEjC3UqZDPCY5vNasmSRGK7JY5Zw', 'HSsMBukTSBxESvd9odf5eXoC4g7L6b7jkwMHP8oowrFr', '6h3182YH3KhVfX6r57MbUm1Jmm8z1Kc3jHXviRG3bLzH', 'CdLfBFb2diGptBRBZRY41tZX7PJHJyKYLA468SqgqSVY')

--AND (log_messages::string LIKE '%CreateCargoPod%')-- OR log_messages::string LIKE '%RemoveShipEscrow%')