select

concat('0x',substr(data,27,40)) as game,

HEX_DECODE_STRING( substr(data,3+13*64,64)) as home,

HEX_DECODE_STRING( substr(data,3+15*64,64) ) as away ,

ethereum.public.udf_hex_to_int( substr(data,3+17*64,64) ) as tags

from optimism.core.fact_event_logs

where origin_function_signature = '0xac2c957c'

and origin_to_address = '0x2b91c14ce9aa828ed124d12541452a017d8a2148'

and topics[0] = '0x889e2060e46779287c2fcbf489c195ef20f5b44a74e3dcb58d491ae073c1370f'

and BLOCK_TIMESTAMP::DATE>=CURRENT_DATE-14

),

sport_data2 as(

select

game,

home, away,

CASE

when tags = 9001 then 'NCAA - American Footbal '

when tags = 9002 then 'NFL - American Footbal '

when tags = 9003 then 'MLB - Baseball '

when tags = 9004 then 'NBA - Basketball'

when tags = 9005 then 'NCAA - Basketball'

when tags = 9006 then 'NHL - Hockey '

when tags = 9007 then 'UFC MMA'

when tags = 9008 then 'WNBA basketball'

when tags = 9010 then 'MLS - Soccer'

when tags = 9011 then 'EPL - Soccer'

when tags = 9012 then 'Ligue 1 - Soccer'

when tags = 9013 then 'Bundesliga - Soccer'

when tags = 9014 then 'La Liga - Soccer'

when tags = 9015 then 'Serie A - Soccer'

when tags = 9016 then 'UEFA Champions League - Soccer'