请考虑以下查询:
SELECT u.id
, u.name
, p.id
FROM users u
LEFT
JOIN posts p
ON p.id IN(
SELECT x.id
FROM posts x
WHERE x.user_id = u.id
ORDER
BY x.featured DESC
LIMIT 10
);
我正在尝试将posts表连接到users表。不过,我只想检索每个用户最多10个帖子。
此方法引发以下错误:
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
是否有其他方法来达到预期的结果?