purifnutty-copper
Updated 2024-12-14
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
28
29
30
31
32
33
34
35
36
›
⌄
⌄
⌄
/*select sum(value) from (
select (utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as value
from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0x2B4141f98B8cD2a03F58bD722D4E8916d2106504')
and ORIGIN_FUNCTION_SIGNATURE='0xb6b55f25'
and TOPICS[0]='0xdceb62ada4e4ec63db2fb9ed65e38a56764ba06e1346b9aebc081ead867fa5a3'
union
select -1.0*(utils.udf_hex_to_int(substr(data,3,66))::int)/1e18 as value
from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0x2B4141f98B8cD2a03F58bD722D4E8916d2106504')
and ORIGIN_FUNCTION_SIGNATURE='0x2e1a7d4d'
and TOPICS[0]='0x6d8fccb210175d9b6d8a076e606aebf0e5f57d186e5d48e8cc5d431a88e5ae6b'
)*/
/*select sum(value) from (
select sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as value from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[1]='0x0000000000000000000000000000000000000000000000000000000000000000'
UNION
select -1.0*sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as value from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[2]='0x0000000000000000000000000000000000000000000000000000000000000000'
)*/
select sum(value) from (
select -1.0*sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as value from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[1]='0x0000000000000000000000002b4141f98b8cd2a03f58bd722d4e8916d2106504'
UNION
select sum((utils.udf_hex_to_int(substr(data,3,66))::int)/1e18) as value from berachain.testnet.fact_event_logs
where CONTRACT_ADDRESS=lower('0xB5A27c33bA2ADEcee8CdBE94cEF5576E2F364A8f')
and TOPICS[0]='0xddf252ad1be2c89b69c2b068fc378daa952ba7f163c4a11628f55a4df523b3ef'
and topics[2]='0x0000000000000000000000002b4141f98b8cd2a03f58bd722d4e8916d2106504'
QueryRunArchived: QueryRun has been archived