SELECT
total_channels,
SUM(spend_money) AS money,
SUM(
spend_money * (
SELECT
url.ratio
FROM
71you_url url
WHERE
url.uid = spend_log.total_channels
AND url.gid = spend_log.gid
) / 100
) AS jsmoney
FROM
71you_spend_log spend_log
WHERE
spend_log.pay_type = 0
GROUP BY
spend_log.total_channels 最佳答案
