应该对子查询使用内部联接,而不是左联接和in子句
SELECT users.id, users.name, t.id
FROM users
INNER JOIN (
SELECT posts.id, posts.user_id
FROM posts
WHERE posts.user_id = users.id
ORDER BY posts.featured DESC
LIMIT 10 ) t on t.user_id = users.id
这样,就不会在in子句中对子查询使用限制,也不会引发错误。两者的错误
LIMIT & IN ....
但不适用于join子查询中的in limit的sue(withou in子句)