CartanGroupbraindrops royalties by artist
Updated 2024-03-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
select
case
when a.tokenid >= 31000000 and a.tokenid <= 31000500 then 'Seven by RedruM'
when a.tokenid >= 30000000 and a.tokenid <= 30000500 then 'corpo | real by Claire Silver'
when a.tokenid >= 29000000 and a.tokenid <= 29000500 then 'Ren'
when a.tokenid >= 28000000 and a.tokenid <= 28000500 then 'Views by Delta Sauce'
when a.tokenid >= 27000000 and a.tokenid <= 27000500 then 'UBK: Ultrabionika by Fernando Jerez'
when a.tokenid >= 26000000 and a.tokenid <= 26000500 then 'ClownVamp'
when a.tokenid >= 25000000 and a.tokenid <= 25000510 then 'Ira Greenberg'
when a.tokenid >= 24000000 and a.tokenid <= 24000500 then 'Ivona Tau'
when a.tokenid >= 23000000 and a.tokenid <= 23000500 then 'Kali Yuga'
when a.tokenid >= 22000000 and a.tokenid <= 22000500 then 'Daniel Greenwood'
when a.tokenid >= 21000000 and a.tokenid <= 21000500 then 'Charlesai'
when a.tokenid >= 17000000 and a.tokenid <= 17000999 then 'huemin'
when a.tokenid >= 16000000 and a.tokenid <= 16000127 then 'Various Artists'
when a.tokenid >= 15000000 AND a.tokenid <= 15000499 then 'Roope Rainisto'
when a.tokenid >= 14000000 AND a.tokenid <= 14000128 then 'Van Arman x Mindshift x ricky'
when a.tokenid >= 13000000 AND a.tokenid <= 13000499 then 'ATNPassion'
when a.tokenid >= 12000000 AND a.tokenid <= 12000512 then 'Entangled Others (Sofia Crespo & Feileacan McCormick)'
when a.tokenid >= 11000000 AND a.tokenid <= 11000500 then 'Nikolay Jetchev'
when a.tokenid >= 10000000 AND a.tokenid <= 10000500 then 'Artemis'
when a.tokenid >= 9000000 AND a.tokenid <= 9000500 then 'Vadim Epstein x COH'
when a.tokenid >= 8000000 AND a.tokenid <= 8000499 then 'Heavens Last Angel'
when a.tokenid >= 7000000 AND a.tokenid <= 7000999 then 'Obvious'
when a.tokenid >= 6000000 AND a.tokenid <= 6000999 then 'Dadabots x Silverstein'
when a.tokenid >= 5000000 AND a.tokenid <= 5000999 then 'Devi Parikh'
when a.tokenid >= 4000000 AND a.tokenid <= 4000499 then 'Xander Steenbrugge'
when a.tokenid >= 3000000 AND a.tokenid <= 3000499 then 'Genesis by Claire Silver'
when a.tokenid >= 2000000 AND a.tokenid <= 2001023 then 'Pindar Van Arman'
when a.tokenid >= 1000000 AND a.tokenid <= 1000999 then 'Gene Kogan'
else null
end as artist,
sum(creator_fee) as royalties_earned
from ethereum.nft.ez_nft_sales a
where nft_address = '0xdfde78d2baec499fe18f2be74b6c287eed9511d7'
QueryRunArchived: QueryRun has been archived