msafadoostsmaller holders votes
    Updated 2022-06-17
    WITH holders AS (

    SELECT max(BLOCK_TIMESTAMP),
    --TOKENID,
    NFT_TO_ADDRESS,
    COUNT(TOKENID) AS counts
    FROM ethereum.core.ez_nft_transfers
    WHERE NFT_ADDRESS = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
    AND NFT_TO_ADDRESS NOT IN (
    '0xd5f279ff9eb21c6d40c8f345a66f2751c4eea1fb',
    '0x55e0f7a3bb39a28bd7bcc458e04b3cf00ad3219e'
    )
    GROUP by 2 HAVING(counts < 2)
    ORDER by 3 DESC
    )
    select --DATE(BLOCK_TIMESTAMP),
    --ORIGIN_FROM_ADDRESS,
    COUNT(ORIGIN_FROM_ADDRESS)
    from ethereum.core.fact_event_logs
    where ORIGIN_TO_ADDRESS = '0x5d2c31ce16924c2a71d317e5bbfd5ce387854039'
    AND EVENT_NAME = 'VoteCast'
    AND ORIGIN_FROM_ADDRESS IN (
    SELECT NFT_TO_ADDRESS FROM holders
    )
    --GROUP by 1
    --ORDER by 2 DESC
    Run a query to Download Data