SELECT

tx_message:txn:note as tx_note,

BASE64_DECODE_string(tx_note) as notes

FROM flipside_prod_db.algorand.transfers

WHERE receiver = 'H5T5FHYHVC2GFEZS6YQP27QVNCSMSNXCVMALDONJXFCL3L5NN4BKDMISGA' AND INNER_TX = 'FALSE' AND notes::string LIKE '%groupIds%'

),

alammex AS ( -- credit sam

select

value as note

from alammex_group_tx,

table(flatten(input => parse_json(notes):groupIds)))

select * from alammex