时间戳

首页 > 解决方案 > laravel 查询进行分页

laravel - laravel 查询进行分页

问题描述

$users =  SELECT users.id, 
                 users.name, 
                 cd.title, 
                 cd.updated_at, 
                 profiles.avatar 
          FROM   `users` 
                 JOIN (SELECT Max(id) max_id, 
                              user_id 
                       FROM   book 
                       GROUP  BY user_id) c_max 
                   ON ( c_max.user_id = users.id ) 
                 JOIN book cd 
                   ON ( cd.id = c_max.user_id ) 
                 JOIN profiles 
                   ON ( profiles.user_id = users.id ) 
          ORDER  BY cd.updated_at DESC

我正在使用它来获取 laravel 查询中的数据

$users = DB::select(DB::raw('SELECT users.id, users.name, cd.title, cd.updated_at, profiles.avatar FROM usersJOIN (SELECT MAX(id) max_id, user_id FROM book GROUP BY user_id ) c_max ON (c_max.user_id = users.id) JOIN book cd ON (cd.id = c_max.user_id) JOIN profiles ON (profiles.user_id = users.id) ORDER by cd.updated_at DESC limit 24 offset 0')) ;

标签： laravelpagination

解决方案

推荐阅读