Query editor
WITH collateral_source AS (SELECT *FROM query_6231640),pause_events AS (SELECTcs.collateral_type,block_time,CASEWHEN topic0 = 0x62e78cea01bee320cd4e420270b5ea74000d11b0c9f74754ebdbfc544b05a258 THEN trueWHEN topic0 = 0x5db9ee0a495bf2e6ff9c91a7834c1ba4fdd244a5e8aa4e537bd38aeae4b073aa THEN falseEND AS is_pausedFROM flare.logs lINNER JOIN collateral_source csON l.contract_address = cs.trove_managerWHERE topic0 IN (0x62e78cea01bee320cd4e420270b5ea74000d11b0c9f74754ebdbfc544b05a258, -- Paused(address)0x5db9ee0a495bf2e6ff9c91a7834c1ba4fdd244a5e8aa4e537bd38aeae4b073aa -- Unpaused(address))),latest_status AS (SELECTcollateral_type,is_pausedFROM (SELECTcollateral_type,is_paused,ROW_NUMBER() OVER (PARTITION BY collateral_type ORDER BY block_time DESC) AS rnFROM pause_events)WHERE rn = 1)SELECTcs.collateral_type,COALESCE(ls.is_paused, false) AS is_pausedFROM collateral_source csLEFT JOIN latest_status lsON cs.collateral_type = ls.collateral_typeORDER BY cs.collateral_type