with payment as (

SELECT to_address as contract_address

, tx_hash

, 1 as token_transfer_index

, 1 as payment_rows

, from_address as buyer

, 'RON' as symbol

, amount

, amount_usd

from ronin.core.ez_native_transfers

WHERE 1=1

AND trace_index = 0

AND to_address in (

'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy

, '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy

)

UNION ALL

--incase other erc20 not native

SELECT to_address as contract_address

, tx_hash

, row_number() over(partition by tx_hash order by event_index) token_transfer_index

, count(*) over(partition by tx_hash) payment_rows

, from_address as buyer

, symbol

, amount

, amount_usd

from ronin.core.ez_token_transfers

WHERE 1=1

AND to_address in (

'0x3b3adf1422f84254b7fbb0e7ca62bd0865133fe3' --Market Gateway Proxy

, '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' --Market Gateway Proxy Multi Send Proxy

)

AND from_address <> '0x21a0a1c081dc2f3e48dc391786f53035f85ce0bc' -- Exclude intermediate cases where MG Multi Send Proxy indirectly forwards tokens to MG Proxy for token distribution

),