SELECT * FROM ( SELECT * FROM article WHERE mark > 0 order by sort_num asc limit 4) AS t1
UNION
SELECT * FROM ( SELECT * FROM article WHERE mark > 0 order by id desc limit 0,10) AS t2
解决办法说明,在内部增加limit 即可,如果没有limit 则排序失效
SELECT * FROM ( SELECT * FROM article WHERE mark > 0 order by sort_num asc limit 4) AS t1
UNION
SELECT * FROM ( SELECT * FROM article WHERE mark > 0 order by id desc limit 0,10) AS t2
解决办法说明,在内部增加limit 即可,如果没有limit 则排序失效