Forefront Tak2023-11-17 09:27 PM
    Updated 2024-01-07



    --select *
    --from near.nft.dim_nft_contract_metadata
    --where CONTRACT_ADDRESS='mint.sharddog.near'

    --tekuno-6.fmilosheski.linkdropv1.near
    --tekuno_scavenger_hunt.nearbalkans.linkdropv1.near
    --tekuno.near




    --select *
    --from near.nft.dim_nft_contract_metadata
    --where CONTRACT_ADDRESS='mint.sharddog.near'





    with a as
    (
    select
    --BLOCK_TIMESTAMP,
    --TX_HASH,
    case when ARGS:data:token_id is not null then ARGS:data:token_id::string else ARGS:data:token_id::string end as id ,
    ARGS:data:name as title ,
    ARGS:data:description as description
    from near.core.fact_actions_events_function_call
    where METHOD_NAME='mint_nft'
    and ACTION_NAME='FunctionCall'
    and RECEIVER_ID='tekuno.near'
    and SIGNER_ID='tekuno.near'
    )
    QueryRunArchived: QueryRun has been archived