Hessishstark_par - nft mints
Updated 2024-05-11
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
›
⌄
with t0 as (SELECT DISTINCT tx_hash as hash
from external.tokenflow_starknet.decoded_traces
where FUNCTION = 'mint' and CONTRACT = '0x01b22f7a9d18754c994ae0ee9adb4628d414232e3ebd748c386ac286f86c3066'),
x as
(SELECT count(DISTINCT tx_hash) as txs, 'Argent NFTs mints' as type
from external.tokenflow_starknet.decoded_transactions join t0 on tx_hash = hash
where
CHAIN_ID = 'mainnet'
and
contract = lower('{{Starknet_address}}')
--'0x07480f307b7c0dc18bfc17ef425f8ad3319b89e1d347897537d9b5fe66b1f7f7'
union
SELECT count(DISTINCT tx_hash) as txs, 'Other transactions' as type
from external.tokenflow_starknet.decoded_transactions
where
CHAIN_ID = 'mainnet'
and tx_hash not in (SELECT DISTINCT hash from t0)
and contract = lower('{{Starknet_address}}')
--'0x07480f307b7c0dc18bfc17ef425f8ad3319b89e1d347897537d9b5fe66b1f7f7'
)
SELECT * from x order by type
QueryRunArchived: QueryRun has been archived