Query editor
WITHhlg_contracts_arbitrum AS (SELECTcontractAddressFROMholograph_factory_arbitrum.HolographFactory_evt_BridgeableContractDeployed),hlg_tokens_arbitrum AS (SELECTcontract_address AS contract,topic3 AS tokenIdFROMarbitrum.logsWHEREcontract_address IN (SELECT*FROMhlg_contracts_arbitrum)AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef -- TransferAND topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000 -- MintingAND topic3 IS NOT NULL -- ERC721 TransferAND tx_hash NOT IN (SELECTevt_tx_hashFROMholograph_operator_arbitrum.HolographOperator_evt_FinishedOperatorJobWHEREevt_block_number = block_number)GROUP BYcontract_address,topic3),hlg_contracts_avalanche_c AS (SELECTcontractAddressFROMholograph_factory_avalanche_c.HolographFactory_evt_BridgeableContractDeployed),hlg_tokens_avalanche_c AS (SELECTcontract_address AS contract,topic3 AS tokenIdFROMavalanche_c.logsWHEREcontract_address IN (SELECT*FROMhlg_contracts_avalanche_c)AND topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef -- TransferAND topic1 = 0x0000000000000000000000000000000000000000000000000000000000000000 -- MintingAND topic3 IS NOT NULL -- ERC721 TransferAND tx_hash NOT IN (SELECTevt_tx_hash