t1 as (

select

proposal_id

from terra.core.fact_governance_votes

where proposal_id >= 3619

),

t2 as (

select

proposal_id,

tx_id

from terra.core.fact_governance_submit_proposal

where proposal_id in (select proposal_id from t1)

),

t3 as (

select

proposal_id,

a.message_value:content:title as title,

a.message_value:content:description as description

from t2

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 t3

using (proposal_id)

group by proposal_id, title

order by votes_count desc