SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('62','6,62','63','6,63','64','6,64','65','6,65','66','6,66','67','6,67','68','6,68','48','6,48','49','6,49','50','6,50','130','6,130','186','6,186','6') 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
時尚快剪美髮就業班
