select
block_timestamp,
signers,
count(*) over () as total_vote_count,
program_id,
tx_id
from
solana.core.fact_events
where
program_id = 'GovaE4iu227srtG2s3tZzB4RmWBzw8sTwrCLZz7kN7rY' -- and tx_id = '9sETY2b2FwVspPRAFGeWNmoD9LfoXAiUf4dzN7Djd3EwKcFyQ4Cu3KQxhWiqvbyqtqZLpC8rjEhCdWN8bwap7cX'
and '{{Address}}' = signers [0]
order by
block_timestamp DESC