shadilTop 5 bettors that loss the most for MMA games
    Updated 2022-08-22
    with query_1 as (select optimism.core.fact_event_logs.event_inputs:account as bettor,
    optimism.core.fact_event_logs.event_inputs:value/pow(10, 18) as bet_total,
    match_name
    from optimism.core.fact_event_logs join (select '0x02f8d02341876daa346539f566fa0ea9aa81d3bb' as match_address, 'David Onama | Nate Landwehr' as match_name
    from dual union
    select '0xafade64a37354da150ba4b02a2aad5d2732cc94d' as match_address, 'Dominick Cruz | Marlon Vera' as match_name
    from dual union
    select '0x21713be89339979ea8e8123cb51d42c9b694419e' as match_address, 'Azamat Murzakanov | Devin Clark' as match_name
    from dual union
    select '0x47d93c73a9aaea30a0249c1c9ea3d9c59e81d06f' as match_address, 'Lukasz Brzeski | Martin Buday' as match_name
    from dual union
    select '0x76c86696c00d151088f6b8b88eeae57aafceebea' as match_address, 'Nina Nunes | Cynthia Calvillo' as match_name
    from dual union
    select '0x9353a9d46611e6a1999ff2a8c1f6982f582ca16a' as match_address, 'Lupita Godinez | Angela Hill' as match_name
    from dual union
    select '0xb304e985624329eb3768a558b4802409b0f24caa' as match_address, 'Tyson Nam | Ode Osbourne' as match_name
    from dual union
    select '0x3eb9a331c1e827bdbe619b6ed83047e2669d0b16' as match_address, 'Ariane Lipski | Priscila Cachoeira' as match_name
    from dual union
    select '0x4c5929df14451e88026a504a7198ff812393d81b' as match_address, 'Josh Quinlan | Jason Witt' as match_name
    from dual union
    select '0x97360fd20820f43c10fdee7099dc152dff3f8e66' as match_address, 'Gerald Meerschaert | Bruno Silva' as match_name
    from dual union
    select '0x23db38bc0f58a3982c8c2a0629128beb40aa7c4d' as match_address, 'Charlie Ontiveros | Gabriel Benitez' as match_name
    from dual union
    select '0x149f5e3695c8b148a295de9098d1d4cdcc15d960' as match_address, 'Da`Mon Blackshear | Youssef Zalal' as match_name
    from dual union
    select '0x741bc82633f05b4ff4ac29a2c267b417feeb3b7b' as match_address, 'Iasmin Lucindo | Yazmin Jauregui' as match_name
    from dual union
    select '0xe12b0c17b94912ae1dcb73a00edbc97f8eaddb69' as match_address, 'Claudio Ribeiro | Ivan Valenzuela' as match_name
    from dual union
    select '0x856ad545c0defcf38a3fd3e8afd0b4b80e9aa240' as match_address, 'Claudia Leite | Hailey Cowan' as match_name
    from dual union
    select '0x33f7d06b1863bf67798ed6b695dd442c429d4f76' as match_address, 'Esteban Ribovics | Thomas Paull' as match_name
    from dual union
    select '0x6ea2acab2b0916d5ba7b2e8554ea6f8cb7c6505b' as match_address, 'Ahmad Hassanzada | Nazim Sadykhov' as match_name
    Run a query to Download Data