LEFT JOIN (
SELECT r.id,COUNT(l.`id`) AS likesNum FROM replys r
LEFT JOIN likes l ON l.telephone_1=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) likesCount ON likesCount.id=r.id
LEFT JOIN (
SELECT r.id,COUNT(s.`id`) AS share_itNum FROM replys r
LEFT JOIN share_it s ON s.telephone_1=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) share_itCount ON share_itCount.id=r.id
LEFT JOIN (
SELECT r.id,COUNT(p.`id`) AS postsNum FROM replys r
LEFT JOIN posts p ON p.source=r.telephone_it
WHERE r.forumid=?
GROUP BY r.`id`
) postsCount ON postsCount.id=r.id ORDER BY createtime DESC
', [1, 1, 1])->paginate(5);
原生SQL查询之后paginate() 分页 是错误的请问应该怎么写
最佳答案