select * from ( select * from news where publish_time> date_add(now(),interval -2 day) )T order by hits desc;
select * from news where publish_time> date_add(now(),interval -2 day) union all select *from news where publish_time <= date_add(now(),interval -2 day) order by hits desc;
select * from news order by (publish_time>CURDATE()-interval 2 day) desc,hits desc
select * from (select * from neworder by (publish_time>curdate()-interval 2 day) desc)a a.hits desc;
select *
from news
where publish_time> date_add(now(),interval -2 day)
)T
order by hits desc;
select * from news
where publish_time> date_add(now(),interval -2 day)
union all
select *from news where publish_time <= date_add(now(),interval -2 day) order by hits desc;
order by (publish_time>CURDATE()-interval 2 day) desc,hits desc
(select * from neworder by (publish_time>curdate()-interval 2 day) desc)a
a.hits desc;