Query editor
WITH addresses AS (SELECTholderAddress ,NFTNameFROM (select distinct "to" as holderAddress,'LINK' AS NFTNameFrom erc721_arbitrum.evt_transferwhere contract_address = 0x50E75cAC7E0b4160aa8d80af9AfDF36043BF2486UNIONselect distinct tx_from as holderAddress,'FRENS' AS NFTNameFrom arbitrum.logswhere contract_address = 0x9191617302Ae1fc02b823530bDd7e167fD43aA36UNIONselect distinct tx_from as holderAddress,'TRUST' AS NFTNameFrom arbitrum.logswhere contract_address = 0x03BECE8b4b627D99fcC7836239054f5a4b7211a8UNIONselect distinct tx_from as holderAddress,'MOON' AS NFTNameFrom arbitrum.logswhere contract_address = 0xbb6C7c4124177a226D61247802Cb5Ef740909716UNIONselect distinct tx_from as holderAddress,'FRENS' AS NFTNameFrom arbitrum.logswhere contract_address = 0xec43373d9eb8e60dc32cd03d70874ef01b134805UNIONselect distinct tx_from as holderAddress,'MOON' AS NFTNameFrom arbitrum.logswhere contract_address = 0x096B7C2FF53C9C189049eFfb05BF962BB25BD464UNIONselect distinct tx_from as holderAddress,'TRUST' AS NFTNameFrom arbitrum.logswhere contract_address = 0x154aa6a67ff5c0c5fe65a71ab35927b92642b492UNIONselect distinct tx_from as holderAddress,'FRENS' AS NFTNameFrom base.logswhere contract_address = 0xec43373d9eb8e60dc32cd03d70874ef01b134805UNIONselect distinct tx_from as holderAddress,'MOON' AS NFTNameFrom base.logswhere contract_address = 0x096B7C2FF53C9C189049eFfb05BF962BB25BD464UNIONselect distinct tx_from as holderAddress,'TRUST' AS NFTName