SELECT

block_timestamp AS date,

tx_id,

signers [0] AS voter,

decoded_instruction:accounts [1] :pubkey AS proposal,

decoded_instruction:args:side AS vote_choice,

decoded_instruction:args:weight / pow(10, 6) AS vote_weight

FROM

solana.core.ez_events_decoded

WHERE 1 = 1

AND block_timestamp :: date >= '2024-11-25'

AND program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY'

AND event_type = 'setVote'

AND proposal = 'CWAwYcLmniqQYnzDh3QGRH6FtymBesJ9dzk1EBvYNBwK'

AND succeeded

AND voter = '{{wallet}}'

),

latest_vote AS (

SELECT

voter,

MAX(date) AS latest

FROM

vote

GROUP BY

voter

date,

tx_id,

v.voter AS "Voter",

TO_CHAR(vote_weight, '999,999,999,999') AS "Vote Weight",

CASE

WHEN v.vote_choice = '1' THEN 'Yes, I am comfortable with this proposal'