flipside

    Paint Canvas contributors
    freemartianPaint Canvas contributors
    Updated 2025-03-11
    -- select * from base.core.ez_decoded_event_logs
    -- where tx_hash = '0xfa59f4d0670c75e9b64bc435b1a6fe7e31da9d5d02f0859455404c1666c87459'

    select
    count(distinct decoded_log:author) as Contributing_painters,
    decoded_log:day as nft_ID,
    count(distinct decoded_log:tokenId) as Contributing_brushes
    from base.core.ez_decoded_event_logs
    where contract_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
    and event_name = 'Painted'
    group by nft_ID


    Last run: about 2 months agoAuto-refreshes every 3 hours
    CONTRIBUTING_PAINTERS
    NFT_ID
    CONTRIBUTING_BRUSHES
    1
    		395
    309
    		395
    2
    		263
    347
    		263
    3
    		482
    251
    		482
    4
    		784
    82
    		784
    5
    		420
    282
    		421
    6
    		550
    94
    		550
    7
    		379
    321
    		379
    8
    		415
    182
    		415
    9
    		596
    217
    		596
    10
    		166
    496
    		166
    11
    		443
    11
    		446
    12
    		195
    461
    		195
    13
    		577
    54
    		577
    14
    		463
    244
    		463
    15
    		130
    578
    		130
    16
    		350
    9
    		364
    17
    		148
    559
    		148
    18
    		162
    512
    		162
    19
    		563
    112
    		563
    20
    		624
    103
    		624
    ...
    581
    8KB
    77s