TO_ADDRESS | CALL_COUNT | |
---|---|---|
1 | 0xad3b67bca8935cb510c8d18bd45f0b94f54a968f | 2 |
2 | 0xcd68591e4f9fa55c4a9938a5574e22517047a055 | 14 |
3 | 0xc3c8a64f2fadd0a836007ef4fe3a76d62dd6759a | 2 |
4 | 0xbac849bb641841b44e965fb01a4bf5f074f84b4d | 2 |
5 | 0x970a0575a3e5a1c76493b5744b90bd0a490b0886 | 2 |
6 | 0x552fcecc218158fff20e505c8f3ad24f8e1dd33c | 5 |
7 | 0x69017801667545db032286167564aacb94a2a2e7 | 3 |
8 | 0x69017801667545db032286167564aacb94a2a2e7 | 2 |
9 | 0x69017801667545db032286167564aacb94a2a2e7 | 2 |
10 | 0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd4 | 2 |
11 | 0x69017801667545db032286167564aacb94a2a2e7 | 3 |
12 | 0x6c0623f2a30821263029345dc9aad6446eb4b025 | 2 |
13 | 0x3f59e7dbdb92cd40ac8bb2d49470cca1bc61b122 | 2 |
14 | 0x3ad53ad1e474be52301f387716086848cef1c335 | 2 |
15 | 0x6c0623f2a30821263029345dc9aad6446eb4b025 | 2 |
16 | 0x62ab2e65cc872f37e72100ab209f568103e9ed46 | 2 |
17 | 0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd4 | 2 |
18 | 0xe1c31f0ee585e87addf493c7b2b9aa88c533aac2 | 2 |
19 | 0x69017801667545db032286167564aacb94a2a2e7 | 2 |
20 | 0x3d45adac77d310051e9a3b8aaef1c9aebdf91fd4 | 2 |
0x07f2e2fE7A091e69389E6996644F1Af09441C7e4electronic-green
Updated 6 days ago
99
1
2
3
4
5
6
7
8
9
10
›
⌄
SELECT
a.TO_ADDRESS,
COUNT(*) AS call_count
FROM bsc.core.fact_traces as a, bsc.core.dim_contracts as b
WHERE
a.to_address = b.address
and SUBSTRING(a.input, 3, 8) = '1626ba7e'
GROUP BY a.TO_ADDRESS, a.input
HAVING COUNT(*) > 1;
Last run: 6 days ago
...
5146
246KB
379s