where SUCCEEDED='TRUE' and MINT='Saber2gLauYim4Mvftnrasomsv6NvAuncvMEZwcLpD1' and ACTION='LOCK' )

, locked as (select sum(AMOUNT) as lamount,date(BLOCK_TIMESTAMP) as ldate from datas

group by ldate)

, proposal_voters_overtime as (select count(VOTER) as vcount,date(flipside_prod_db.solana.fact_proposal_votes.BLOCK_TIMESTAMP) as vdate

from flipside_prod_db.solana.fact_proposal_votes

inner join datas on datas.SIGNER=VOTER

group by vdate)

, proposal_voters_participation as (select count(1) as vcount,VOTER,date(flipside_prod_db.solana.fact_proposal_votes.BLOCK_TIMESTAMP) as vdate

from flipside_prod_db.solana.fact_proposal_votes

inner join datas on datas.SIGNER=VOTER

group by VOTER,vdate)

, proposal_every_voters_participation as (select count(1) as vcount,VOTER from flipside_prod_db.solana.fact_proposal_votes

inner join datas on datas.SIGNER=VOTER

group by VOTER)

, gauges_voters_overtime as (select count(VOTER) as vcount,date(flipside_prod_db.solana.fact_gauges_votes.BLOCK_TIMESTAMP) as vdate

from flipside_prod_db.solana.fact_gauges_votes

inner join datas on datas.SIGNER=VOTER

group by vdate)

, gauges_voters_participation as (select count(1) as vcount,VOTER,date(flipside_prod_db.solana.fact_gauges_votes.BLOCK_TIMESTAMP) as vdate

from flipside_prod_db.solana.fact_gauges_votes

inner join datas on datas.SIGNER=VOTER

group by VOTER,vdate)

, gauges_every_voters_participation as (select count(1) as vcount,VOTER from flipside_prod_db.solana.fact_gauges_votes

inner join datas on datas.SIGNER=VOTER

group by VOTER)

, proposal as (select distinct VOTER from flipside_prod_db.solana.fact_proposal_votes

inner join datas on datas.SIGNER=VOTER)

, gauges as (select distinct VOTER from flipside_prod_db.solana.fact_gauges_votes

inner join datas on datas.SIGNER=VOTER)

, common_p_q as (select * from proposal where VOTER in (select VOTER from gauges))

select * from locked