取消訂閱
    
 
SELECT prod.id,prod.dataXML,prod.imgXML FROM 201400070_product prod,201400070_product_cate cate WHERE prod.cateid = cate.id and (prod.inuse in ('1') or (prod.inuse='2' and prod.sdate <= '2024-03-29' and prod.edate >='2024-03-29')) and prod.cateid=1 order by cate.seq asc,prod.seq desc