Sbhn_NPsupposed-ivory
    Updated 2025-03-16
    select
    count(distinct symbol) as tokens
    from ink.core.fact_event_logs
    join ink.core.ez_token_transfers using(tx_hash)
    where topic_0 in ('0x4b5824a0f21039d7160b2a57d8c140cae3ba13e4f15bcd879cc63e4964681a9e','0x0d29d7b2727600087ca17290038d4c09dc340440df666c931e739ad49594669e')
    and origin_to_address = '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
    and concat('0x', right(regexp_substr_all(SUBSTR(DATA, 3, len(DATA)), '.{64}')[4],40)) != '0x1d74317d760f2c72a94386f50e8d10f2c902b899'
    and amount>0


    Last run: 22 days ago
    TOKENS
    1
    271
    1
    7B
    19s