NakedCollector2024-07-08 09:04 PM
    Updated 2024-07-08
    WITH name AS (
    SELECT
    *
    FROM
    ethereum.nft.dim_nft_collection_metadata,
    LATERAL FLATTEN(input => TRAITS) AS flattened_traits
    WHERE
    NFT_ADDRESS = lower('0x49cF6f5d44E70224e2E23fDcdd2C053F30aDA28B')
    and flattened_traits.value:value::string = 'Human'
    )
    SELECT
    *
    FROM
    name;

    owners as ()

    QueryRunArchived: QueryRun has been archived