SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date FROM tb_course WHERE cate1 IN (1,5) AND training_type = 1 AND ((on_date <= '2020-01-18' AND off_date > '2020-01-18' AND cdateA >= '2020-01-18') 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 239
