select 'Ethereum' as source_chain,

case when data ilike '%4176616c616e636865%' then 'Avalanche'

when data ilike '%506f6c79676f6e%' then 'Polygon'

when data ilike '%417262697472756d%' then 'Arbitrum'

when data ilike '%4175726f7261%' then 'Aurora'

when data ilike '%457468657265756d%' then 'Ethereum'

when data ilike '%62696e616e6365%' then 'Binance Smart Chain'

when data ilike '%46616e746f6d%' then 'Fantom'

when data ilike '%63656c6f%' then 'Celo'

when data ilike '%4d6f6f6e6265616d%' then 'Moonbeam'

else null end as destination_chain,

from ethereum.core.fact_event_logs

where contract_name is null

and event_name is null

and contract_address != '0x4f4495243837681061c4743b74b3eedf548d56a5'

and origin_to_address = '0xce16f69375520ab01377ce7b88f5ba8c48f8d666'

and origin_function_signature in ('0x8ca3bf68','0x3c659741')

and destination_chain is not null

and tx_status = 'SUCCESS'

union all

select 'Avalanche' as source_chain,

case when data ilike '%4176616c616e636865%' then 'Avalanche'

when data ilike '%506f6c79676f6e%' then 'Polygon'

when data ilike '%417262697472756d%' then 'Arbitrum'

when data ilike '%4175726f7261%' then 'Aurora'

when data ilike '%457468657265756d%' then 'Ethereum'

when data ilike '%62696e616e6365%' then 'Binance Smart Chain'

when data ilike '%46616e746f6d%' then 'Fantom'

when data ilike '%63656c6f%' then 'Celo'

when data ilike '%4d6f6f6e6265616d%' then 'Moonbeam'

else null end as destination_chain,