select fc.tx_hash

,parse_json(fc.args):id as proposal

,parse_json(fc.args):action as vote

,t.tx_receiver as proposer

,t.tx_signer as voter

from near.core.fact_actions_events_function_call fc

join near.core.fact_transactions t

on fc.tx_hash = t.tx_hash

where proposer in ('marketing.sputnik-dao.near', 'creatives.sputnik-dao.near') and method_name = 'act_proposal' --and args:id = 13

and deposit = 0

)

select proposer,

count (distinct proposal) as number_of_proposals

from votes_raw

group by 1

order by 1 desc