select * from table1 order by 阅读数 desc limit 5
union all
select * from table1 where id not in (select id from 阅读数 order by 阅读数 desc limit 5) order by 时间
如果前5条不包括在分页查询里的话建议分两句查。
前5句也包括分页的话
SELECT * FROM ((SELECT * FROM 表 ORDER BY 阅读数 DESC LIMIT 5) UNION (SELECT * FROM 表 ORDER BY 发表时间 DESC)) a LIMIT 10,20
前提是分页数大于5