b.to_address

bsc.core.fact_transactions as a,

bsc.core.fact_traces as b,

bsc.core.fact_event_logs as c

DATE(a.block_timestamp) = '2024-03-18'

and DATE(b.block_timestamp) = '2023-03-18'

and DATE(c.block_timestamp) = '2023-03-18'

and a.TX_HASH = b.TX_HASH

and b.TX_HASH = c.TX_HASH

and substring(b.input, 3, 8) = '84800812'

and c.topics[0] = '0x8c5be1e5ebec7d5bd14f71427d1e84f3dd0314c0f7b2291e5b200ac8c7c3b925'

and ethereum.public.udf_hex_to_int (c.DATA) > ethereum.public.udf_hex_to_int ('0x1431E0FAE6D7217CAA0000000')

and '0x' || substring(topics[1], 27, 67) = b.to_address

and b.input like concat('%', substring(c.topics[2], 27, 67), '%')