thinkphp5 原生SQL 接paginate() 分页

浏览:1400 发布日期:2018/03/31 分类:求助交流 关键字: thinkphp5 SQL paginate()
$data5 = Db::query('SELECT r.*,likesCount.likesNum,share_itCount.share_itNum,postsCount.postsNum FROM replys r
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() 分页 是错误的请问应该怎么写
最佳答案
评论() 相关
后面还有条评论,点击查看>>