CASE WHEN proposal_id = '{{proposal_id}}' THEN 'A' ELSE 'B' END as prop,

COUNT (DISTINCT a.tx_id) as n_votes,

count(DISTINCT c.attribute_value) as n_participants

FROM cosmos.core.fact_msg_attributes a, cosmos.core.fact_msg_attributes b, cosmos.core.fact_msg_attributes c

WHERE a.msg_type = 'proposal_vote' and b.msg_type = 'proposal_vote'

AND a.attribute_key = 'proposal_id'

AND b.attribute_key = 'option'

AND a.tx_id = b.tx_id

AND a.tx_id = c.tx_id

AND c.msg_type = 'coin_spent' AND c.attribute_key = 'spender'

AND a.tx_succeeded = 'TRUE'

GROUP BY proposal_id

ORDER BY proposal_id