SELECT f.id,
substring_index(GROUP_CONCAT(u.portrait ORDER BY fr.created_date ASC),',',5) AS portrait
FROM
forum f
LEFT JOIN forum_reply fr ON fr.forum_id=f.id
LEFT JOIN users u ON u.id=fr.user_id
GROUP BY f.id
分组取前5条
最新推荐文章于 2024-07-22 03:10:33 发布