SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('401','400,401','402','400,402','403','400,403','404','400,404','405','400,405','406','400,406','407','400,407','408','400,408','409','400,409','400') AND charge = 0 AND ((on_date <= '2019-01-19' AND off_date > '2019-01-19' AND cdateA >= '2019-01-19') 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
