block_timestamp as date,

parse_json(args):proposal:kind:AddMemberToRole:member_id AS add_to_council

from near.core.fact_actions_events_function_call

where tx_hash in (select tx_hash from near.core.fact_transactions where tx_receiver like 'marketing.sputnik-dao.near')

and method_name like 'add_proposal'

),table1 as (select

add_to_council,

min(date) as date,

count(*) as num

from main

group by add_to_council

having num < 500

order by date desc

select

date::date as date,

add_to_council as council_address

from table1