select

date(proposal_end_time) as date,

proposal_title,

voter,

voting_power,

vote_option

from ethereum.core.ez_snapshot

where space_id = 'opcollective.eth'

and proposal_title != '%Test%'

and proposal_title != 'Final test'

and proposal_title != 'Test Proposal'

-- and voting_power > 0.1

order by date asc,

proposal_title,

voting_power desc),

ex_power as (

select

voter,

sum(voting_power) as executed_voting_power

from op_votes

group by voter

select

voter,

executed_voting_power

from ex_power

order by executed_voting_power desc