最新提币的用户

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 '提币金额',d.volume AS '交易量',c.times 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=2) AS b,
(SELECT user_id,COUNT(1) AS 'times' FROM `management`.`t_wallet_transaction_history` WHERE transaction_type=2 GROUP BY user_id) AS c,
(SELECT client_id,SUM(ABS(volume)) AS volume FROM clear.`t_trade` GROUP BY client_id) d
WHERE a.`user_id`=b.user_id AND a.`user_id`=c.`user_id` AND a.`user_id`=d.`client_id` AND `country_code`=86 AND a.`telephone` IS NOT NULL ORDER BY b.operate_time DESC  LIMIT 1000;