,concat('0x',substr(A.input_data,34,40)) as game_contract

,IFF (B.CONTRACT_ADDRESS in ('0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' , '0x8c6f28f2f1a3c87f0f938b96d27520d9751ec8d9') ,(RAW_AMOUNT/pow (10,18)), (RAW_AMOUNT/pow (10,6))) as "BET AMOUNT"

from optimism.core.fact_transactions A

LEFT JOIN optimism.core.fact_token_transfers B ON A.TX_HASH=B.TX_HASH

where B.tx_hash in(

select tx_hash

from optimism.core.fact_token_transfers

WHERE TO_ADDRESS='0x170a5714112daeff20e798b6e92e25b86ea603c1'

and from_address != '0x0000000000000000000000000000000000000000'

and from_address != '0x061b87122ed14b9526a813209c8a59a633257bab'

AND BLOCK_TIMESTAMP > '2022-08-08')

AND A.BLOCK_TIMESTAMP > '2022-08-08'

AND