with tab1 as (

select TX_HASH

,TO_ADDRESS

from polygon.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0x88dcdc47d2f83a99cf0000fdf667a468bb958a78'

and ORIGIN_FUNCTION_SIGNATURE in ('0xcdd1b25d')),

tab2 as (

select date_trunc('week',BLOCK_TIMESTAMP) as week

,case

when DECODED_LOG:srcChainId='7700' then 'Canto'

when DECODED_LOG:srcChainId='1' then 'Ethereum Mainnet'

when DECODED_LOG:srcChainId='250' then 'Fantom Opera'

when DECODED_LOG:srcChainId='42161' then 'Arbitrum One'

when DECODED_LOG:srcChainId='1313161554' then 'Aurora Mainnet'

when DECODED_LOG:srcChainId='56' then 'BNB Smart Chain Mainnet'

when DECODED_LOG:srcChainId='1666600000' then 'Harmony Mainnet Shard 0'

when DECODED_LOG:srcChainId='288' then 'Boba Network'

when DECODED_LOG:srcChainId='2222' then 'Kava EVM'

when DECODED_LOG:srcChainId='592' then 'Astar'

when DECODED_LOG:srcChainId='324' then 'zkSync Era Mainnet'

when DECODED_LOG:srcChainId='10' then 'OP Mainnet'

when DECODED_LOG:srcChainId='1030' then 'Conflux eSpace'

when DECODED_LOG:srcChainId='59144' then 'Linea'

when DECODED_LOG:srcChainId='592' then 'Astar'

when DECODED_LOG:srcChainId='128' then 'Huobi ECO Chain Mainnet'

when DECODED_LOG:srcChainId='336' then 'Shiden'

when DECODED_LOG:srcChainId='44' then 'Darwinia Crab Network'

when DECODED_LOG:srcChainId='43114' then 'Avalanche C-Chain'

when DECODED_LOG:srcChainId='248' then 'Oasys Mainnet' end as ch_name

,TX_HASH

from polygon.core.ez_decoded_event_logs

where DECODED_LOG:srcChainId is not null )

select week

,ch_name