tian7linear-chocolate
Updated 2024-11-01
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
--A user must call the settleCurrentAndCreateNewAuction() function to settle the previous auction and create a new one.
--trigger an event of AuctionSettled
SELECT
SUBSTRING(t.data, 1, 66),
SUBSTRING(t.data, 27, 40),
SUBSTRING(t.data, 67, len(t.data)-66),
t.*
FROM
berachain.testnet.fact_event_logs t
WHERE contract_address = lower('0x95fa5e857E90237215C4522723B7069D42eb83EB')
and topics[0] = '0xc9f72b276a388619c6d185d146697036241880c36654b1a3ffdad07c24038d99' --AuctionSettled event
--and topics[1] = '0x0000000000000000000000000000000000000000000000000000000000000000'
--and topics[2] = '0x0000000000000000000000000000000000000000000000000000000000000000'
and tx_hash='0x60ab1433d18bd5b30be45ceabd4b110293139386f1260c5f902fdf69896096e2'
select 1800000000000000000000/1e18
QueryRunArchived: QueryRun has been archived