充值赠0.1活动

update

select m.user_id,ci.display_name_zh,u.email,u.telephone,m.updated_at,c.margin_balance/100000000 as '保证金余额',c.available/100000000 as '可用余额',T.total_deposit AS 'deposit',T.times_deposit AS 'times_d',W.total_withdraw AS 'withdraw', W.times_withdraw AS 'times_w'
from management.t_deposit_bonus as m
join clear.t_account as c
on m.user_id=c.client_id
left join management.t_trade_user as u
on m.user_id=u.user_id
left join management.t_country_info as ci
on u.country_code=ci.telephone_code
LEFT JOIN (SELECT SUM(amount/1e8) AS total_deposit, COUNT(1) AS times_deposit, USER_ID FROM management.t_deposit WHERE status = '1' GROUP BY USER_ID) AS T ON m.user_id = T.USER_ID  
LEFT JOIN (SELECT SUM(amount/1e8) AS total_withdraw, COUNT(1) AS times_withdraw, USER_ID FROM management.t_withdraw WHERE status = 2 GROUP BY USER_ID) AS W ON m.user_id = W.USER_ID 
where m.type=1

select m.user_id,m.updated_at,c.margin_balance/100000000 as '保证金余额',c.available/100000000 as '可用余额'
from management.t_deposit_bonus as m
join clear.t_account as c
on m.user_id=c.client_id
where m.type=1