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: 1 day agoAuto-refreshes every 3 hours
    CONTRIBUTING_PAINTERS
    NFT_ID
    CONTRIBUTING_BRUSHES
    1
    		111
    581
    		111
    2
    		124
    583
    		124
    3
    		123
    579
    		123
    4
    		293
    355
    		293
    5
    		438
    117
    		438
    6
    		296
    356
    		296
    7
    		393
    179
    		393
    8
    		418
    302
    		418
    9
    		371
    324
    		371
    10
    		598
    41
    		608
    11
    		610
    50
    		611
    12
    		520
    53
    		520
    13
    		115
    582
    		115
    14
    		208
    435
    		208
    15
    		167
    497
    		167
    16
    		230
    388
    		231
    17
    		159
    535
    		159
    18
    		103
    655
    		103
    19
    		593
    223
    		593
    20
    		103
    653
    		103
    ...
    673
    9KB
    118s