Query editor
WITHhlg_contracts_arbitrum AS (SELECTcontractAddressFROMholograph_factory_arbitrum.HolographFactory_evt_BridgeableContractDeployed),hlg_tokens_arbitrum AS (SELECTlogs.contract_address AS contract,logs.topic3 AS tokenIdFROMarbitrum.logs AS logsWHERElogs.contract_address IN (SELECT*FROMhlg_contracts_arbitrum)AND logs.topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef -- TransferAND logs.topic3 IS NOT NULL -- ERC721 TransferGROUP BYlogs.contract_address,logs.topic3),hlg_contracts_avalanche_c AS (SELECTcontractAddressFROMholograph_factory_avalanche_c.HolographFactory_evt_BridgeableContractDeployed),hlg_tokens_avalanche_c AS (SELECTlogs.contract_address AS contract,logs.topic3 AS tokenIdFROMavalanche_c.logs AS logsWHERElogs.contract_address IN (SELECT*FROMhlg_contracts_avalanche_c)AND logs.topic0 = 0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef -- TransferAND logs.topic3 IS NOT NULL -- ERC721 TransferGROUP BYlogs.contract_address,logs.topic3),hlg_contracts_bnb AS (SELECTcontractAddressFROMholograph_factory_bnb.HolographFactory_evt_BridgeableContractDeployed),hlg_tokens_bnb AS (SELECTlogs.contract_address AS contract,