laravel 查询文章表每个类别下的最新n条数据？

Question

如题，不知有没有好的解决方案？

Answer 1

需要一个类别, 一个类别的查. 没什么好办法一次查询.

Answer 2

select a.* 
from 
    title a,
    (select group_concat(tid order by tid desc) gtid 
     from title group by type) b
where find_in_set(a.tid,b.gtid) between 1 and n
order by type,tid desc;