case when game in ( '0x6f50Fc73057FeCa16ed86C32192e76FB79d90606') then'Boston Red Sox vs New York Yankees (HOME)'

when game in ( '0x144a0f95f6062f07e6f0ef20b54c8e70208d0f60') then'Leon Edwards vs Kamaru Usman (HOME)'

when game in ( '0x79275654af8283eded1a624a7f8df8f6958bb2e4') then'Cincinnati Reds vs Chicago Cubs (HOME)'

when game in ( '0x9509596197a55e514ef79c2dae6960324a980324') then'Nottingham Forest vs West Ham Unit... (HOME)'

when game in ( '0x13b741207de88b8fb7d15682bcbbde94dc7eed1c') then'Salernitana vs AS Roma (HOME)'

when game in ( '0xd4f163c0827f2967439ff4e35e057b4807f5a6cf') then'Bayern Munich vs VfL Wolfsburg (HOME)'

when game in ( '0xb5a3db8d284bb9248e76382dcfe119376c2f9282') then 'Chelsea vs Tottenham Hotspur (HOME)'

when game in ( '0x58b5863de1d8f906eb8cadced7fab3054ee01be1') then 'Chicago Cubs vs St. Louis Cardinals (HOME)'

when game in ( '0xf10c220fa183dea8a3663e76d638775cac04784a') then 'Los Angeles Angels vs Minnesota Tw... (HOME)'

when game in ( '0x7fc15b461ae75b41f9b55c83075e10382131ee20') then 'Inter Milan vs Spezia (HOME)'

when game in ('0x6f50fc73057feca16ed86c32192e76fb79d90606') then 'Boston Red Sox vs New York Yankees (HOME)'

when game in ('0x5e61516ac65644fe1990f421226562db02e0f821') then 'Kansas City Chiefs vs Green Bay Pa... (HOME)'

when game in ('0xca0e09bbb819c63e85eca319d2ab597f85349300') then 'Real Sociedad vs Barcelona'

when game in ('0x2e017fb43ae83214e68bf90115986905092fb66d') then 'Leeds United vs Chelsea'

when game in ('0xbc70b2b4aa4b2660618734184675a0ed2c8f96ee') then 'Leon Edwards vs Kamaru Usman'

when game in ('0xf41a1ee8b4c1d7fdc855c2ec54d6404c133b9a97') then 'Cincinnati Reds vs Chicago Cubs'

else game End as game_name

from (select game, VALUE

from (select sum(TX_JSON:receipt:logs[1]:decoded:inputs:value/ pow(10,18))as value, tx_json:receipt:logs[10]:address as game,

CASE

when TX_JSON:receipt:logs[1]:address = '0xda10009cbd5d07dd0cecc66161fc93d7c9000da1' then 'dai'

else null

end as currency

from optimism.core.fact_transactions

where tx_hash in (SELECT tx_hash from (select tx_hash

from optimism.core.fact_token_transfers

where ORIGIN_FROM_ADDRESS in ( select "Unique Users" from (select DISTINCT ORIGIN_FROM_ADDRESS as "Unique Users"

from optimism.core.fact_token_transfers

where ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and BLOCK_TIMESTAMP > CURRENT_DATE - 14) )

and ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and FROM_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'

and TO_ADDRESS in ( select "Unique Users" from (select DISTINCT ORIGIN_FROM_ADDRESS as "Unique Users"

from optimism.core.fact_token_transfers

where ORIGIN_TO_ADDRESS = '0x170a5714112daeff20e798b6e92e25b86ea603c1'