• 
• 
• 

SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('9','1,9','10','1,10','11','1,11','12','1,12','13','1,13','14','1,14','16','1,16','29','1,29','30','1,30','181','1,181','1') 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

• 課程搜尋
• 免費課程
• 好康活動
• 公職專區