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