e.block_timestamp,

e.origin_from_address,

e.tx_hash,

tx_fee,

from

ronin.core.fact_event_logs e

left join ronin.core.fact_transactions t on e.tx_hash = t.tx_hash

where

e.tx_succeeded = TRUE

and origin_to_address in (

'0xb806028b6ebc35926442770a8a8a7aeab6e2ce5c',

'0x02790f32ad7e7eaaecfb0ad21950829932f1a2ee',

'0x7eae20d11ef8c779433eb24503def900b9d28ad7',

'0x1b918543b518e34902e1e8dd76052bee43c762ff'

)

),

t1 AS (

SELECT

origin_from_address AS user,

MIN(block_timestamp) AS min_platform_tx

FROM base

GROUP BY origin_from_address

),

t2 AS (

SELECT

a.user,

a.min_platform_tx,

MIN(b.block_timestamp) AS min_tx

FROM t1 a

LEFT JOIN ronin.core.fact_transactions b

ON a.user = b.from_address

GROUP BY a.user, a.min_platform_tx