select *,

-- data, topics,

block_timestamp,

tx_hash,

origin_from_address as address_that_levelled,

-- data, topics, contract_address

-- -- origin_to_address,

-- contract_address,

-- concat ('0x', substr(topics[1], 27, 40)) :: string as from_address,

-- concat ('0x', substr(topics[2], 27, 40)) :: string as to_address,

livequery.utils.udf_hex_to_int(SUBSTR(data, 120, 11)) + 1 as curr_level,

livequery.utils.udf_hex_to_int(SUBSTR(data, 59, 8)) as token_id

from base.core.fact_event_logs

where true

and contract_address = '0xd2bc150a09c6ec5b2c39309be6e771da67f863cd'

and origin_function_signature = '0x0ce90ec2'

),

latest_lvl as (

select

token_id, max(curr_level) as curr_level

from level_data

group by 1

order by token_id

),

health_data as (

select

data,

block_timestamp,

livequery.utils.udf_hex_to_int(SUBSTR(data, 59, 8)) as token_id,

livequery.utils.udf_hex_to_int(SUBSTR(data, 120, 11)) as curr_health,

livequery.utils.udf_hex_to_int(SUBSTR(data, 185, 11)) as max_health

from base.core.fact_event_logs