对竞价单查询两个状态的列表,进行排序, 然后在第一个状态时按照gmt_create创建时间降序在第二个状态按照开始时间start_time升序
SELECT *
from auction
where
auction_status in (2,3)
order by auction_status desc,
case when auction_status=3 then gmt_create end desc,
case when auction_status=2 then start_time end asc
limit 0,100