SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('167','166,167','168','166,168','169','166,169','170','166,170','171','166,171','172','166,172','173','166,173','174','166,174','175','166,175','176','166,176','177','166,177','188','166,188','390','166,390','178','166,178','166') AND ((on_date <= '2019-05-25' AND off_date > '2019-05-25' AND cdateA >= '2019-05-25') OR cdateA = '0000-00-00') ORDER BY (CASE WHEN cdateA = '0000-00-00' THEN 0 ELSE 1 END) DESC,cdateA ASC,autono DESC LIMIT 20
