select
substr(tx.input_data, 1, 10) as function_signature,
'0x' || substr(lg.data, 27, 40) as borrower,
livequery.utils.udf_hex_to_int(substr(lg.data, 67, 64)) as lienId,
livequery.utils.udf_hex_to_int(substr(lg.data, 131, 64)) as positionAmount,
lg.data
-- ,tx.input_data
from blast.core.fact_transactions tx
inner join blast.core.fact_event_logs lg USING (tx_hash)
where
lg.tx_hash = '0x1b7eeefbc54ae3b62f1d3867f9d5d42e11fc2b5c2ba0f7dd0243ba8bff4293dd'
-- and lg.contract_Address = '0x121b5ac4de4a3e6f4171956bc26ceda40cb61a56'
and lg.event_index = 14