mysql多个字段排序和多个搜索条件

1.根据PARENT_ID为空，AIR_DATE不为空，AIR_DATE不等于0000-00-00 00:00:00条件查询；

2.首先按AIR_DATE降序排列；再根据HOT降序排列；

select NAME,  AIR_DATE, HOT from ( select NAME, AIR_DATE, HOT from CONTENT_INFO where PARENT_ID is null and AIR_DATE is not null and AIR_DATE <> '0000-00-00 00:00:00' order by AIR_DATE desc) as c order by c.HOT desc