SELECT

DECODED_LOG:token as t_a

from

ethereum.core.ez_decoded_event_logs

where

contract_Address = '0x3eb879cc9a0ef4c6f1d870a40ae187768c278da2'

and EVENT_NAME = 'UpdateTokenSupported'

),

all_p as (

SELECT

POOL_ADDRESS,

TOKENS:token0 as a_token0,

TOKENS:token1 as a_token1,

SYMBOLS:token0 as n_token0,

SYMBOLS:token1 as n_token1,

DECIMALS:token0 as d_token0,

DECIMALS:token1 as d_token1,

POOL_NAME

FROM

ethereum.defi.dim_dex_liquidity_pools

where

(

TOKENS:token0 in (

SELECT

*

from

all_T

)

or TOKENS:token1 in (

SELECT

*

from

all_T

)

)