• 
• 
• 
• 

SQL:SELECT autono,cate1,charge,ctitle,zip,cdateA,on_date,training_type FROM tb_course WHERE cate1 IN (1,5) AND cate2 IN ('74','8,74','75','8,75','76','8,76','77','8,77','78','8,78','81','8,81','80','8,80','79','8,79','8') AND charge = 0 AND ((on_date <= '2019-03-19' AND off_date > '2019-03-19' AND cdateA >= '2019-03-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

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