WITH gaming_users AS (

SELECT

ft.from_address AS user,

MIN(ft.block_timestamp) AS first_gaming_tx

FROM $query('6bbdf5a1-9212-4cc9-9983-bce1f246fbeb') ct

JOIN ronin.core.fact_transactions ft

ON ct.contract_address = ft.to_address

GROUP BY ft.from_address

),

lp_users AS (

SELECT

origin_from_address AS user,

MIN(block_timestamp) AS first_lp_tx

FROM (

SELECT

block_timestamp,

origin_from_address

FROM ronin.core.ez_native_transfers

WHERE origin_from_address = from_address

AND origin_to_address IN (

'0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7',

'0x7cf0fb64d72b733695d77d197c664e90d07cf45a'

)

UNION ALL

SELECT

block_timestamp,

origin_from_address

FROM ronin.core.ez_token_transfers

WHERE origin_from_address = from_address

AND origin_to_address IN (

'0xc05afc8c9353c1dd5f872eccfacd60fd5a2a9ac7',

'0x7cf0fb64d72b733695d77d197c664e90d07cf45a'