Query editor
WITH-- BridgeOut requestsavalanche_c_bridge_request AS (SELECTevt_block_time AS requestDate,43114 AS chain,messageHash AS jobHash,evt_tx_hash AS requestTxFROMholograph_operator_avalanche_c.HolographOperator_evt_CrossChainMessageSent),bnb_bridge_request AS (SELECTevt_block_time AS requestDate,56 AS chain,messageHash AS jobHash,evt_tx_hash AS requestTxFROMholograph_operator_bnb.HolographOperator_evt_CrossChainMessageSent),ethereum_bridge_request AS (SELECTevt_block_time AS requestDate,1 AS chain,messageHash AS jobHash,evt_tx_hash AS requestTxFROMholograph_operator_ethereum.HolographOperator_evt_CrossChainMessageSent),optimism_bridge_request AS (SELECTevt_block_time AS requestDate,10 AS chain,messageHash AS jobHash,evt_tx_hash AS requestTxFROMholograph_operator_optimism.HolographOperator_evt_CrossChainMessageSent),polygon_bridge_request AS (SELECTevt_block_time AS requestDate,137 AS chain,messageHash AS jobHash,evt_tx_hash AS requestTxFROMholograph_operator_polygon.HolographOperator_evt_CrossChainMessageSent),-- Cross-chain messagesavalanche_c_lz_cross_chain_msg AS (SELECT43114 AS chain,jobHash,evt_tx_hash AS msgTxFROMholograph_operator_avalanche_c.HolographOperator_evt_AvailableOperatorJob),bnb_lz_cross_chain_msg AS (SELECT56 AS chain,jobHash,