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