SELECT 
result_without_conversion.user_id,
result_without_conversion.email,
result_without_conversion.balance * (SELECT r.`rate` FROM `rate` r WHERE r.`currency` = result_without_conversion.`currency` ORDER BY r.`time` DESC LIMIT 1) balance,
result_without_conversion.latest_login_time,
result_without_conversion.trades_done,
result_without_conversion.total_deposited * (SELECT r.`rate` FROM `rate` r WHERE r.`currency` = result_without_conversion.`currency` ORDER BY r.`time` DESC LIMIT 1) total_deposited,
result_without_conversion.total_withdrawal * (SELECT r.`rate` FROM `rate` r WHERE r.`currency` = result_without_conversion.`currency` ORDER BY r.`time` DESC LIMIT 1) total_withdrawal,
result_without_conversion.open_trades_volume * (SELECT r.`rate` FROM `rate` r WHERE r.`currency` = result_without_conversion.`currency` ORDER BY r.`time` DESC LIMIT 1) open_trades_volume

FROM (
        SELECT 
                usr.`id` user_id, 
                usr.`email` email, 
                IFNULL(usr.`name`, '') name, 
				acc.`currency` currency, 
                acc.`cash` balance, 
                usr.`last_login` latest_login_time, 
                (1000 * UNIX_TIMESTAMP() - usr.`last_login`) duration_latest_session, 
                COUNT(CASE WHEN ord.`open_time` > usr.`last_login` THEN 1 ELSE NULL END) trades_done, 
                (SELECT COALESCE(SUM(CASE WHEN pmt.`sum` > 0 THEN pmt.`sum` ELSE 0 END), 0) FROM `payment` pmt WHERE pmt.`account_id` = acc.`id`) total_deposited, 
                ABS((SELECT COALESCE(SUM(CASE WHEN pmt.`sum` < 0 THEN pmt.`sum` ELSE 0 END), 0) FROM `payment` pmt WHERE pmt.`account_id` = acc.`id`)) total_withdrawal, 
                SUM(CASE WHEN ord.`status` = 'PENDING' AND ord.`open_time` > usr.`last_login` THEN ord.`quantity` ELSE 0 END) open_trades_volume 
                    FROM `user` usr 
                        JOIN `account` acc ON usr.`account_id` = acc.`id` 
                        LEFT JOIN `order` ord ON acc.`id` = ord.`account_id` 
                    WHERE usr.`id` IN (2001004,2001025,2001166) 
                         AND acc.`broker_id` = 1
                         AND acc.`type` = 'REAL' 
                GROUP BY acc.`id`) result_without_conversion;