with maintable as (

select *,

regexp_substr (sender,'[a-zA-Z]+|\d+') as Sender_Chain,

regexp_substr (receiver,'[a-zA-Z]+|\d+') as Receiver_Chain

from axelar.core.fact_transfers

where transfer_type in ('IBC_TRANSFER_IN','IBC_TRANSFER_OUT')

and TX_SUCCEEDED = 'TRUE'),

osmousers as (

select receiver as bridger,

block_timestamp as bridge_date

from maintable

where receiver_chain = 'osmo'

group by 1,2),

gdeposit as (

select 'Governance Deposit' as Action_Type,

block_timestamp,

tx_id,

depositor as osmouser

from osmosis.core.fact_governance_proposal_deposits t1 join osmousers t2 on t1.depositor = t2.bridger and t1.block_timestamp > t2.bridge_date

where tx_status = 'SUCCEEDED'),

gpropose as (

select 'Governance Propose' as Action_Type,

block_timestamp,

tx_id,

proposer as osmouser

from osmosis.core.fact_governance_submit_proposal t1 join osmousers t2 on t1.proposer = t2.bridger and t1.block_timestamp > t2.bridge_date

where tx_status = 'SUCCEEDED'),

gvote as (

select 'Governance Vote' as Action_Type,

block_timestamp,

tx_id,