t1 as (

select

tx_id,

proposal_id,

a.message_value:content:title as title,

a.message_value:content:description as description

from terra.core.fact_governance_submit_proposal b

join terra.core.ez_messages a

using(tx_id)

select

concat(title, ' (Id: ', proposal_id, ')') as proposal,

count(distinct tx_id) as votes_count,

count(distinct voter) as voters_count

from terra.core.fact_governance_votes

join t1

using (proposal_id)

group by proposal_id, title

order by voters_count desc

limit 10