with

MAINTAB as

(select

BLOCK_TIMESTAMP ,

tx_id from

sei.core.fact_msg_attributes

where

MSG_TYPE = 'wasm'

and

ATTRIBUTE_KEY = 'action'

and

ATTRIBUTE_VALUE = 'withdraw_liquidity' )

, tb2 as (

select

tx_id ,

ATTRIBUTE_VALUE as LPer

from

sei.core.fact_msg_attributes

where

MSG_TYPE = 'wasm'

and

ATTRIBUTE_KEY = 'sender'

) ,

tb4 as

(

select

tx_id ,

ATTRIBUTE_VALUE as pool_address