/*充提查询*/

SELECT FROM_UNIXTIME(b.operate_time/1000,('%Y-%m-%d %H:%i:%S'))  AS '充值时间',a.`user_id` AS '用户ID',a.`user_name` AS '用户名',b.amount/1e8 AS '充值金额',c.times AS '充值次数',d.amount/1e8 AS '提现金额',e.times2 AS '提现次数',a.`telephone` AS '电话',a.`email` AS '邮箱',a.`country_id` AS '国家代码' FROM 
`management`.`t_trade_user` AS a,
(SELECT user_id,amount,operate_time FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=1) AS b,
(SELECT user_id,COUNT(1) AS 'times' FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=1 GROUP BY user_id) AS c,
(SELECT user_id,amount,operate_time FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=2) AS d,
(SELECT user_id,COUNT(2) AS 'times2' FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=2 GROUP BY user_id) AS e
WHERE a.`user_id`=b.user_id AND a.`user_id`=c.`user_id` AND a.`user_id`=d.`user_id`   AND a.`user_id`=e.`user_id`  AND `country_code`=81 
ORDER BY b.operate_time DESC limit 200