SELECT a.id, sum(a.tingdou_amount) 挺豆余额, sum(a.tbi_amount) T币余额, sum(a.tdian_amount) T点余额 FROM
(SELECT userid as id,
avail_amount as tingdou_amount,
0 as tbi_amount,
0 as tdian_amount
FROM db_wlt_gameplatform.game_user_account
WHERE userid in (123)
UNION ALL
SELECT
user_id as id,
0 as tingdou_amount,
available_coin/500 as tbi_amount,
0 as tdian_amount
from db_wlt_gameplatform.game_customize_user_account
WHERE user_id in (123)
UNION ALL
SELECT
u.id as id,
0 as tingdou_amount,
0 as tbi_amount,
SUM( t.points )/500 as tdian_amount
FROM db_wlt_gamepoint.points_user_total t
INNER JOIN db_wlt_gameplatform.game_user u ON t.passport_id = u.passport_id
WHERE u.id in (123)
AND (t.overdue_date > NOW( ) OR overdue_date = '0000-00-00 00:00:00')
AND t.delete_flag =0
GROUP BY u.id)
AS a
group by a.id
(SELECT userid as id,
avail_amount as tingdou_amount,
0 as tbi_amount,
0 as tdian_amount
FROM db_wlt_gameplatform.game_user_account
WHERE userid in (123)
UNION ALL
SELECT
user_id as id,
0 as tingdou_amount,
available_coin/500 as tbi_amount,
0 as tdian_amount
from db_wlt_gameplatform.game_customize_user_account
WHERE user_id in (123)
UNION ALL
SELECT
u.id as id,
0 as tingdou_amount,
0 as tbi_amount,
SUM( t.points )/500 as tdian_amount
FROM db_wlt_gamepoint.points_user_total t
INNER JOIN db_wlt_gameplatform.game_user u ON t.passport_id = u.passport_id
WHERE u.id in (123)
AND (t.overdue_date > NOW( ) OR overdue_date = '0000-00-00 00:00:00')
AND t.delete_flag =0
GROUP BY u.id)
AS a
group by a.id