Query editor
with all_chains as(SELECT 'ethereum' as blockchain, namespace, name, addressFROM ethereum.contractsWHERE address = {{contract}}UNION ALLSELECT 'arbitrum' as blockchain, namespace, name, addressFROM arbitrum.contractsWHERE address = {{contract}}UNION ALLSELECT 'avalanche_c' as blockchain, namespace, name, addressFROM avalanche_c.contractsWHERE address = {{contract}}UNION ALLSELECT 'gnosis' as blockchain, namespace, name, addressFROM gnosis.contractsWHERE address = {{contract}}UNION ALLSELECT 'optimism' as blockchain, namespace, name, addressFROM optimism.contractsWHERE address = {{contract}}UNION ALLSELECT 'bnb' as blockchain, namespace, name, addressFROM bnb.contractsWHERE address = {{contract}}UNION ALLSELECT 'fantom' as blockchain, namespace, name, addressFROM fantom.contractsWHERE address = {{contract}}UNION ALLSELECT 'goerli' as blockchain, namespace, name, addressFROM goerli.contractsWHERE address = {{contract}}UNION ALLSELECT 'polygon' as blockchain, namespace, name, addressFROM polygon.contractsWHERE address = {{contract}}UNION ALLSELECT 'celo' as blockchain, namespace, name, addressFROM celo.contractsWHERE address = {{contract}}