1. SELECT FROM_UNIXTIME(c.trade_time/1000,('%Y-%m-%d %H:%i:%S'))  AS '最新交易时间',a.`user_id` AS '用户ID',a.`user_name` AS '用户名',b.margin_balance/1e8 AS '保证金',a.`telephone` AS '电话',a.`email` AS '邮箱',a.`country_id` AS '国家代码' FROM 
    2. `management`.`t_trade_user` AS a,
    3. (SELECT client_id,margin_balance FROM `clear`.`t_account` WHERE `margin_balance` <> 0) AS b,
    4. (SELECT client_id,MAX(trade_time) AS trade_time  FROM `clear`.`t_trade` GROUP BY client_id) AS c
    5. WHERE a.`user_id`=b.client_id AND a.`user_id`=b.client_id AND `country_code`=86 AND a.`telephone` IS NOT NULL ORDER BY c.trade_time LIMIT ${limit};