sdfs555sym🎄
Updated 2023-04-09Copy Reference Fork
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
›
⌄
SELECT
user_address,
usd_value_now,
token_name
FROM
ethereum.core.ez_current_balances AS T
-- WHERE REGEXP_COUNT(T.user_address, '(ab|10|ba|a1){2}') >= 2
WHERE SUBSTR(REVERSE(SUBSTR(T.user_address, 1, 22)), 1, 4) = SUBSTR(T.user_address, 23, 4)
-- WHERE T.user_address LIKE '0xcafe%' AND REGEXP_COUNT(T.user_address, 'cafe') >= 1
-- WHERE (T.user_address LIKE '0x%' AND T.user_address LIKE '%554dc')
-- OR T.user_address LIKE '0x%012345' OR T.user_address LIKE '0x12345%' OR T.user_address LIKE '0x%12345')
AND T.token_name != 'Saitama Inu'
AND T.token_name != 'KickToken'
AND T.token_name != 'BurnXToken'
AND T.token_name != 'Orbler'
AND T.token_name != 'ParaToken'
AND T.token_name != 'Step.app'
AND T.token_name != 'BaaSid'
AND T.token_name != 'DoRen'
AND T.token_name != 'Infinity'
AND T.token_name != 'CRYNcoin'
AND T.token_name != 'WEN LAMBO'
AND T.token_name != 'Maya Preferred'
AND T.token_name != 'CVP Token'
AND T.token_name != 'Lucky Block Network'
AND T.token_name != 'WiBX Utility Token'
AND T.token_name != 'IMSMART'
AND T.token_name != 'dobuy'
AND T.token_name != 'DGLCOIN'
AND T.token_name != 'WadzPay Token'
AND T.token_name != 'Quantfury Token'
AND T.token_name != 'MegaCryptoPolis $MEGA Token (MEGA)'
AND T.token_name != 'Smart Application Chain'
AND T.token_name != 'P2P Solutions Foundation'
AND T.token_name != 'OKB'
AND T.token_name != 'Beach Token'
Run a query to Download Data