篩選條件 分類:所有分類;地區:所有縣市,共 1 筆
SELECT autono,ctitle,cate1,aNo,charge,zip,addr,cdateA,oNo FROM tb_course WHERE 1=1 AND (cate1=1 OR cate1=5) AND oNo IN(SELECT oNo FROM tb_limit WHERE category=2 AND unit0 LIKE '%38%') AND ((on_date <= '2024-03-28' AND off_date > '2024-03-28' AND cdateA >= '2024-03-28') OR cdateA = '0000-00-00') ORDER BY (CASE WHEN cdateA = '0000-00-00' THEN 0 ELSE 1 END) DESC,cdateA,RAND() LIMIT 0,20