Query editor
WITH all_ordinars AS (SELECTbet_id,bet_time,affiliate,bettor,amount,odds,odds as initial_odds,CASE WHEN is_freebet THENCASEWHEN status in ('Canceled','cancelled') THEN -amountWHEN status not in ('Canceled','cancelled') and payoutAmount < 0 THEN -amount * oddsELSE 0ENDELSE payoutAmountEND AS payoutAmount,CASE WHEN is_freebet THENCASEWHEN status in ('Canceled','cancelled') THEN 0WHEN status not in ('Canceled','cancelled') and GGR < 0 THEN -amount * (odds - 1)WHEN GGR >= 0 THEN amountENDELSE GGREND AS GGR,status,chain,'ordinar' as bet_type,is_freebet,version,resolve_time,CASE WHEN (coef_margin is NOT NULL) AND (status = 'cancelled') THEN 0 ELSE coef_margin END AS true_coef_margin,False as is_liveFROM query_4746705WHERE version = 'V3'),all_combos AS (SELECTbet_id,bet_time,affiliate,bettor,amount,true_odds as odds,odds as initial_odds,-payoutAmount,GGR,status,chain,'combo' as bet_type,False as is_freebet,version,resolve_time,coef_margin as true_coef_margin,False as is_liveFROM query_2831919WHERE version = 'V3' and affiliate=0x5f7c1ade486ef52d03f38f6363585079f8dd229c) ,all_live as (