saadiqProof Ecosystem Wallets
Updated 2023-04-18
999
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
›
⌄
-- forked from aabfe962-a4ce-40e1-b116-456ff8d9dcef
SELECT
user_address,
sum(
CASE
WHEN contract_address IN ('0x08d7c0242953446436f34b4c78fe9da38c73668d') THEN current_bal_unadj
ELSE 0
END
) AS proof_count,
CASE
WHEN proof_count > 0 THEN 1
ELSE 0
END AS has_proof_pass,
sum(
CASE
WHEN contract_address IN ('0x23581767a106ae21c074b2276d25e5c3e136a68b') THEN current_bal_unadj
ELSE 0
END
) AS moonbirds_count,
CASE
WHEN moonbirds_count > 0 THEN 1
ELSE 0
END AS has_moonbird,
sum(
CASE
WHEN contract_address IN ('0x1792a96e5668ad7c167ab804a100ce42395ce54d') THEN current_bal_unadj
ELSE 0
END
) AS oddities_count,
CASE
WHEN oddities_count > 0 THEN 1
ELSE 0
END AS has_oddity,
sum(
CASE
Run a query to Download Data