'ethereum' as chain,

tx_hash,

concat('0x',substr(data::string, 27, 40)) as lbp_contract

from ethereum.core.fact_event_logs

where topics[0] = '0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc'

and contract_address = '0x0516a838c4c3225bd57ffc40768a634f6adf4e4b'

and block_timestamp::date >= '2023-12-01'

union all

select

'arbitrum' as chain,

tx_hash,

concat('0x',substr(data::string, 27, 40)) as lbp_contract

from arbitrum.core.fact_event_logs

where topics[0] = '0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc'

and contract_address = '0x880f17fb7b1d5aafaf36d0ac9d5a81f5c543d71d'

and block_timestamp::date >= '2023-12-01'

union all

select

'avalanche' as chain,

tx_hash,

concat('0x',substr(data::string, 27, 40)) as lbp_contract

from avalanche.core.fact_event_logs

where topics[0] = '0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc'

and contract_address = lower('0xA5033A6BDb31E52Ce6ba9c67Bff7331aC2686e72')

and block_timestamp::date >= '2023-12-01'

union all

select

'base' as chain,

tx_hash,

concat('0x',substr(data::string, 27, 40)) as lbp_contract

from base.core.fact_event_logs

where topics[0] = '0x83a48fbcfc991335314e74d0496aab6a1987e992ddc85dddbcc4d6dd6ef2e9fc'

and contract_address = lower('0x880f17FB7b1D5AaFaf36d0ac9d5A81f5c543d71d')

and block_timestamp::date >= '2023-12-01'

union all