LittlerDataRagnarok Users minting
    Updated 9 days ago
    -- forked from Ragnarok Landverse Item minting @ https://flipsidecrypto.xyz/edit/queries/2cd606df-4487-47fc-b784-7e436e6d0c59

    with item_mints as (
    select
    count(tx_hash) mints
    ,nft_to_address as user
    from bsc.nft.ez_nft_transfers
    where block_timestamp > '2023-09-15'
    and event_type = 'mint'
    and nft_address = '0x9d2e6134af5b63498d15546f2701837f001c6043'
    group by 2
    )

    select
    user
    ,mints
    from item_mints
    order by 2 desc
    Last run: 9 days agoAuto-refreshes every 3 hours
    USER
    MINTS
    1
    0xb82c30d3b8109a27511549c5e2a19bdbda23ca571955
    2
    0xfc44ad84c5ecb8244a7693d3310a3325eb9ad17b845
    3
    0x239d7ea03ad230d7265fbcecdbe1eb7ea94e644d789
    4
    0xbded133372f839ec67879200c49e0f0a6b297bd6774
    5
    0x9d85603d776d0821036331208b32c30a42d77853694
    6
    0xe532024ab65bdcee05eca909ea22343529598093676
    7
    0xa9be732befb248783654e5b9dd88e2dd165342f4663
    8
    0x71a6dabfb2c6c254ed599969a5bcd3f4532a086a662
    9
    0x2d0ee24f732325af3aa0f1564159409f587a9834609
    10
    0xfc3e5c655e93759ab5d092201c40b3208c397b3c603
    11
    0x98f41d5863deccffed652fca4188c6855b3fcb74594
    12
    0x12709319185e84cd5fb9e4bf56a72ee20fd652b0558
    13
    0xfae26b66a594ee3ba1768cb6afa64a19ec809af4545
    14
    0xa627902dee6deaed2b85a7ebb06fdb331a1a6598545
    15
    0xdde52b1d8774914bd79f6ff4c3f247afc08b1e92527
    16
    0xadd2c03290867bee73940c9500e2ab14bdecfb6d523
    17
    0x789162b7173e885aad01f12669a1032613c40b72516
    18
    0x583258a5a555989cc5a7e8b9e3c86b82daaa34b7511
    19
    0x00bc61b7c13759e80d9bdf98b86b50dca12f53da498
    20
    0x09f0ab350ba2532748fb2b5ed61a6c55037b1b52468
    ...
    8297
    402KB
    122s