1111進修網

SELECT c.autono,c.cate1,c.cate2,c.ctitle,c.aNo,c.charge,c.zip,c.addr,c.cdateA,c.cperiod,c.ctime,c.oNo,c.training_type,l.cname FROM tb_course c INNER JOIN tb_limit l ON c.oNo = l.oNo WHERE 1 = 1 AND cate1 IN ('1','2','5') AND (c.ctitle LIKE '%進修%' OR c.intro LIKE '%進修%' OR c.keyword LIKE '%進修%' OR l.cname LIKE '%進修%') AND l.category = 2 AND ((on_date <= '2019-07-16' AND off_date > '2019-07-16' AND cdateA >= '2019-07-16') OR cdateA = '0000-00-00') ORDER BY (CASE WHEN cdateA = '0000-00-00' THEN 0 ELSE 1 END) DESC,cdateA ASC,c.autono DESC

最前頁 1 2 3 4 5 6 7 8 9 10 下一頁 下十頁 最後頁