Updated 2025-01-24
    with beans_data
    AS
    (
    select
    livequery.live.udf_api (
    'https://api.dune.com/api/v1/query/4611816/results?api_key=RHbPbkgZ50RyFP0QazXfUlalXFyd7nql'
    ):data:result:rows as data
    ),
    beans_data2
    AS
    (
    SELECT
    value:nft_tokenID AS token_id
    from TABLE(FLATTEN(input => select data from beans_data )) f
    )

    SELECT
    token_id
    FROM
    beans_data2

    Last run: 3 months ago
    TOKEN_ID
    1
    19298
    2
    18416
    3
    1693
    4
    12244
    5
    19140
    6
    12302
    7
    2113
    8
    296
    9
    2393
    10
    12015
    11
    15945
    12
    276
    13
    3039
    14
    1006
    15
    8843
    16
    14827
    17
    12936
    18
    5246
    19
    7287
    20
    3954
    ...
    17272
    159KB
    3s