1. /* 所有0.01bonus用户的运营数据 */
    2. SELECT E.in_client_id,U.language, U.country_code, FROM_UNIXTIME(U.register_time/1000,('%Y-%m-%d %H:%i:%S')) AS register_time, T.total_deposit AS 'deposit',T.times_deposit AS 'times_d',T.total_withdraw AS 'withdraw', T.times_withdraw AS 'times_w', A.margin_balance/100000000 AS margin_balance, A.margin_balance/100000000-T.total_deposit+T.total_withdraw-0.01 AS 'PnL',
    3. TRADE.volume, TRADE.netFee
    4. FROM management.t_donation_transfer AS E
    5. LEFT JOIN management.t_trade_user U
    6.     ON E.in_client_id = U.USER_ID
    7. LEFT JOIN (
    8.     SELECT USER_ID, transaction_type, 
    9.     count(if(transaction_type='1',true,null)) as 'times_deposit',
    10.     count(if(transaction_type='2',true,null)) as 'times_withdraw',
    11.     SUM(IF(transaction_type='1',amount/100000000,0)) AS 'total_deposit',
    12.     SUM(IF(transaction_type='2',amount/100000000,0)) AS 'total_withdraw'
    13.     FROM management.t_wallet_transaction_history WHERE transaction_type IN ('1','2')
    14.     GROUP BY USER_ID) AS T
    15.     ON E.in_client_id = T.USER_ID 
    16. LEFT JOIN  `t_account` as A
    17. ON E.in_client_id = A.client_id
    18. LEFT JOIN 
    19.     (SELECT client_id, SUM(taker_fee/1e8 - ABS(maker_fee/1e8)) AS netFee, SUM(trade_volume)AS volume FROM affiliate.t_daily_trade GROUP BY client_id ) AS TRADE
    20. ON TRADE.client_id = E.in_client_id
    21. WHERE activity_name='PROFESSIONALTRADERS0_01' and transfer_status = 7