flipside

    asleep-aqua
    purifasleep-aqua
    Updated 2025-02-09
    with plugins as (select concat('0x',substr(TOPICS[1], 27,64)) as plugin, concat('0x',substr(TOPICS[2], 27,64)) as gauge from berachain.testnet.fact_event_logs
    where (ORIGIN_TO_ADDRESS=lower('0x580ABF764405aA82dC96788b356435474c5956A7') or ORIGIN_TO_ADDRESS=lower('0x2363BB86cD2ABF89cc059A654f89f11bCceffcA9')
    or ORIGIN_TO_ADDRESS=lower('0x1f9505Ae18755915DcD2a95f38c7560Cab149d9C'))
    and ORIGIN_FUNCTION_SIGNATURE='0xd8867fc8'
    and topics[0]='0xb920b936f556d443772609e0cc06a72c3bb67fc606de10dcdd51323d1ddbc7fc')

    select tx_hash from berachain.testnet.fact_event_logs
    where ORIGIN_TO_ADDRESS in (select plugin from plugins)
    and ORIGIN_FUNCTION_SIGNATURE='0x2f4f21e2'

    QueryRunArchived: QueryRun has been archived