Query editor
WITH proposals AS (SELECT proposalid, voteendFROM zksync_zksync.zkgovopsgovernor_evt_proposalcreatedWHERE proposalid NOT IN (SELECT proposalid FROM zksync_zksync.zkgovopsgovernor_evt_proposalcanceled)UNION ALLSELECT proposalid, voteendFROM zksync_zksync.zktokengovernor_evt_proposalcreatedWHERE proposalid NOT IN (SELECT proposalid FROM zksync_zksync.zktokengovernor_evt_proposalcanceled)UNION ALLSELECT proposalid, voteendFROM zksync_zksync.zkprotocolgovernor_evt_proposalcreatedWHERE proposalid NOT IN (SELECT proposalid FROM zksync_zksync.zkprotocolgovernor_evt_proposalcanceled)),proposals_ranked AS (SELECTproposalid,from_unixtime(voteend) AS voteend,ROW_NUMBER() OVER (ORDER BY voteend ASC) AS proposal_rankFROM proposals),proposals_with_next AS (SELECTproposalid,voteend,proposal_rank,COALESCE(LEAD(voteend) OVER (ORDER BY proposal_rank),CAST(DATE_TRUNC('day', CURRENT_TIMESTAMP) AS timestamp)) AS next_voteendFROM proposals_ranked),votes AS (SELECT voter, proposalid FROM zksync_zksync.zkgovopsgovernor_evt_votecastUNION ALLSELECT voter, proposalid FROM zksync_zksync.zktokengovernor_evt_votecastUNION ALLSELECT voter, proposalid FROM zksync_zksync.zkprotocolgovernor_evt_votecast),active_voters AS (SELECTp.proposalid AS anchor_proposalid,p.voteend AS anchor_voteend,p.next_voteend,p.proposal_rank AS anchor_rank,v.voterFROM proposals_with_next pJOIN proposals_ranked prevON prev.proposal_rank >= p.proposal_rank - 4AND prev.proposal_rank <= p.proposal_rankJOIN votes vON v.proposalid = prev.proposalidWHERE p.proposal_rank >= 5