SELECT
a.*, c.username
FROM
(
SELECT
userid,
yseid AS id,
\'30\' AS tradeType,
score,
exchangeRatio,
amt AS allFee,
\' \' AS last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
status_explain AS `explain`,
`status` AS ddStatus,
(
SELECT
yt01id
FROM
yi_trade01
WHERE
srcid = id
) AS yt01id
FROM
yi_score_exchange
UNION ALL
SELECT
userid,
yscid AS id,
tradeType,
score,
\' \' AS exchangeRatio,
\' \' AS allFee,
last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
`explain`,
`status` AS ddStatus,
\' \' AS yt01id
FROM
yi_score_change
) AS a
LEFT JOIN yi_score_change b ON a.id = b.yscid AND a.userid != b.userid
LEFT JOIN sys_login_user c ON b.userid = c.userid AND a.userid != b.userid
WHERE
a.userid = '.$userid;
a.*, c.username
FROM
(
SELECT
userid,
yseid AS id,
\'30\' AS tradeType,
score,
exchangeRatio,
amt AS allFee,
\' \' AS last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
status_explain AS `explain`,
`status` AS ddStatus,
(
SELECT
yt01id
FROM
yi_trade01
WHERE
srcid = id
) AS yt01id
FROM
yi_score_exchange
UNION ALL
SELECT
userid,
yscid AS id,
tradeType,
score,
\' \' AS exchangeRatio,
\' \' AS allFee,
last_score,
createTime AS ddCreatetime,
createTime,
LEFT (createTime, 10) AS ddCreatedate,
`explain`,
`status` AS ddStatus,
\' \' AS yt01id
FROM
yi_score_change
) AS a
LEFT JOIN yi_score_change b ON a.id = b.yscid AND a.userid != b.userid
LEFT JOIN sys_login_user c ON b.userid = c.userid AND a.userid != b.userid
WHERE
a.userid = '.$userid;