SELECT
a.id,
a.order_type,
a.user_id,
GROUP_CONCAT(b.star_id) AS starIdStr,
GROUP_CONCAT(c.weibo_user_id) AS weiboIdStr,
sum(order_amount) AS sumPrice,
a.order_time
FROM
tb_order_info AS a
INNER JOIN tb_order_star AS b
INNER JOIN tb_star AS c
WHERE
(
a.id = b.order_id
AND b.star_id = c.id
)
group by a.id
order by a.order_time desc
分組后按user_id 取時間最近的那一條 。怎么取 求大神 ，php思路也行。
分組后按user_id 取時間最近的那一條 。 php思路也行。
慕無忌1623718
2019-03-18 16:53:31
