with vote as (
select
block_id,
sender,
base64_decode_string(tx_message:txn:note::string) as note,
substr(note, position('[', note, 1)) as vote,
row_number() over (partition by sender order by block_id desc) as rownumber
from algorand.payment_transaction
where receiver = 'GULDQIEZ2CUPBSHKXRWUW7X3LCYL44AI5GGSHHOQDGKJAZ2OANZJ43S72U'
and amount is null
and note like '%af/gov1:j[3,%'
qualify rownumber = 1
)
select distinct vote, position(',', vote, 1), substr(vote, position(',', vote, 1) + 2, 1) from vote