purifbullas spammers
Updated 2024-11-12
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
›
⌄
with activity as (
select from_address as user, count(*) as txs from berachain.testnet.fact_transactions
where to_address=lower('0x5aD441790c3114e0AB27816abdB0c9693cd96399') -- queue
and BLOCK_TIMESTAMP between timestamp '2024-11-09 12:00' and timestamp '2024-11-12 12:00'
and TX_SUCCEEDED
group by 1
UNION ALL
select from_address as user, count(*) as txs from berachain.testnet.fact_transactions
where to_address=lower('0x6679732D6C09c56faB4cBf589E01F5e41A2d9e67') --factory
and BLOCK_TIMESTAMP between timestamp '2024-11-09 12:00' and timestamp '2024-11-12 12:00'
and TX_SUCCEEDED
group by 1
UNION ALL
select from_address as user, count(*) as txs from berachain.testnet.fact_transactions
where to_address=lower('0x12cF1dC4A8d66187202511a706E90Dfb7BE8a80C') --tools
and BLOCK_TIMESTAMP between timestamp '2024-11-09 12:00' and timestamp '2024-11-12 12:00'
and TX_SUCCEEDED
group by 1
)
select user, sum(txs) as txs from activity
group by 1
order by txs desc limit 23
QueryRunArchived: QueryRun has been archived