SELECT

value[0]::string as MAIN_WALLET,

value[1]::string as RELATED_WALLET,

value[2]::string AS TOTAL_RELATED_WALLETS,

value[3]::string AS RELATED_TRANSACTIONS_COUNT,

value[4]::string AS ACTION

FROM

(

SELECT

livequery.live.udf_api('https://flipsidecrypto.xyz/api/queries/29c8e177-7601-4ebf-acaa-02af05fee050/latest-run') as response

),

lateral FLATTEN (input => response:data:result:rows)

),

combined_txs AS (

SELECT 'Polygon' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH, BLOCK_TIMESTAMP

FROM polygon.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

OR TO_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

UNION ALL

SELECT 'Optimism' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH, BLOCK_TIMESTAMP

FROM optimism.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

OR TO_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

UNION ALL

SELECT 'Arbitrum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH, BLOCK_TIMESTAMP

FROM arbitrum.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

OR TO_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

UNION ALL

SELECT 'Ethereum' AS chain, FROM_ADDRESS, TO_ADDRESS, TX_HASH, BLOCK_TIMESTAMP

FROM ethereum.core.fact_transactions

WHERE FROM_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

OR TO_ADDRESS IN (SELECT RELATED_WALLET FROM base_query)

UNION ALL