Query editor
witharbitrum_transfers as (select distinct "from" as unique_usersfrom tether_arbitrum.ArbitrumExtension_evt_Transferwhere trueand evt_block_number > 98354147and to = 0x20513ba6A4717c67e14291331BC99dd2aCE90038 -- USDT Arbitrum),polygon_USDC_transfers as (select distinct "from" as unique_usersfrom circle_polygon.UChildAdministrableERC20_evt_Transferwhere trueand evt_block_number > 38564671and to = 0x2a838AB9b037db117576db8D0DcC3B686748EF7c -- LP USDC Polygon),polygon_USDT_transfers as (select distinct "from" as unique_usersfrom tether_polygon.UChildERC20_evt_Transferwhere trueand evt_block_number > 41594860and to = 0x7043e4e1c4045424858ecbced80989feafc11b36 -- LP USDT Polygon),gnosischain_transfers as (select distinct src as unique_usersfrom wxdai_gnosis.WXDAI_evt_Transferwhere dst = 0x204e7371Ade792c5C006fb52711c50a7efC843ed -- LP Gnosis V2),base_transfers as (select distinct src as unique_usersfrom weth_base.weth9_evt_transferwhere dst = 0xf22e9e29728d6592eb54b916ba9f464d9f237db1 -- Base),bettors as (SELECTdistinct bettor as unique_usersFROM dune.azuro.result_ordinars_combos_resolved)SELECTcount(distinct unique_users) as usersFROM (SELECT * FROM arbitrum_transfersUNION ALLSELECT * FROM polygon_USDC_transfersUNION ALLSELECT * FROM polygon_USDT_transfersUNION ALLSELECT * FROM gnosischain_transfersUNION ALLSELECT * FROM base_transfersUNION ALLSELECT * FROM bettors)_