最近首页推荐内容改版
mysql需要先max 之后再group by获取最大值的数据
需要用到子查询 特此记录
$arrWhere = array();
$arrWhere[] = ['created_at', '>', $intTime];
$objQuery = QuestionStockModel::where($arrWhere)
->orderBy('likenum', 'desc');
$arrQuestionId = \DB::table(\DB::raw("({$objQuery->toSql()}) as questionstock"))
->groupBy('questionid')
->orderBy('id', 'desc')
->mergeBindings($objQuery->getQuery()) //注意这里需要合并绑定参数
->get();
生成的sql如下
select * from (select * from `gupiao_questionstock` where (`created_at` > '1529994994') order by `likenum` desc) as questionstock group by `questionid` order by `id` desc limit 3 offset 0