with multiple_txs as (
select
source_transaction_hash
,count(*) as multiple_transactions
from external.layerzero.fact_transactions_snapshot
group by 1
having multiple_transactions > 1
),
polygon as (
select
*
from polygon.core.ez_decoded_event_logs as event_logs
join multiple_txs on event_logs.tx_hash = multiple_txs.source_transaction_hash
limit 1
)
select
*
from polygon
--limit 1
--where source_chain ilike '%apto%'
/*
arbitrum nova, arbitrum, aurora, avalanche, base, blast, bsc, ethereum, gnosis