rezarwzBonded_tokens creatorbids
    Updated 2025-02-07
    SELECT
    TOKENS:token1 as Bonded_tokens
    FROM
    base.defi.dim_dex_liquidity_pools
    where
    TOKENS:token1 in (
    SELECT
    CAST(CONTRACT_ADDRESS AS VARCHAR) AS token_address
    FROM
    base.core.ez_token_transfers
    WHERE
    FROM_ADDRESS = '0x0000000000000000000000000000000000000000'
    AND tx_hash IN (
    SELECT
    DISTINCT nft.tx_hash
    FROM
    base.nft.ez_nft_transfers nft
    WHERE
    nft.NFT_ADDRESS = LOWER('0x6623206875C37bcEcF67c362d4dd1c96bD5C34d8')
    and EVENT_TYPE = 'mint'
    )
    and origin_to_address != LOWER('0x6623206875C37bcEcF67c362d4dd1c96bD5C34d8')
    )
    Last run: 13 days ago
    BONDED_TOKENS
    1
    0xd63aaeec20f9b74d49f8dd8e319b6edd564a7dd0
    2
    0x9aeb3ac3ca6c5a7df8147a4dfe08cbf49f6bfbbc
    3
    0x9aeb3ac3ca6c5a7df8147a4dfe08cbf49f6bfbbc
    4
    0x5df5c4e690bd5fd79168162618d93801d855010d
    5
    0xa9fb265261ca5be0ba37459b9d70ec0ad0675e5b
    6
    0xcad8bf0446bc786789767c5231229751a1d83f78
    7
    0xfc48314ad4ad5bd36a84e8307b86a68a01d95d9c
    8
    0xdbafcf1fecb4a592cd96a5e879285df1ca4cf149
    9
    0xd63aaeec20f9b74d49f8dd8e319b6edd564a7dd0
    10
    0xca70ba83cdf7ea37f4724ceb01df10eab7698510
    11
    0x5dcd47c5d853e467bc67cd0d807c7dcd97705f24
    12
    0xfc48314ad4ad5bd36a84e8307b86a68a01d95d9c
    13
    0x7a0ed2cf03422d0b9a4ecd8d46fe93b1158f22f5
    14
    0x8a455c262602afe5f099a9b8f990025c87d365fe
    15
    0xfc48314ad4ad5bd36a84e8307b86a68a01d95d9c
    16
    0xc2712e902253ac0fda017f861ca4130c0863fd1e
    17
    0xfc48314ad4ad5bd36a84e8307b86a68a01d95d9c
    18
    0x8a455c262602afe5f099a9b8f990025c87d365fe
    19
    0x498417518c446a28e9ea65d04255e207f2c82db3
    20
    0xd63aaeec20f9b74d49f8dd8e319b6edd564a7dd0
    ...
    164
    8KB
    115s