purifexuberant-fuchsia
Updated 2025-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
select sender, sum(amount) as amount from (
select concat('0x',substr(TOPICS[1], 27,64)) as sender, count(-1.0) as amount
from sei.core_evm.fact_event_logs
where contract_address = '0x7f51575f486e26f83e575a3fe77db71032e4d124'
and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
group by 1
union all
select concat('0x',substr(TOPICS[2], 27,64)) as sender, count(1.0) as amount
from sei.core_evm.fact_event_logs
where contract_address = '0x7f51575f486e26f83e575a3fe77db71032e4d124'
and topics[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
group by 1
)
group by 1 having sum(amount)>0
QueryRunArchived: QueryRun has been archived