|
|
SELECT prod.id,prod.dataXML,prod.imgXML FROM tw_product prod,tw_product_cate cate WHERE prod.cateid = cate.id and (prod.inuse in ('1') or (prod.inuse='2' and prod.sdate <= '2020-09-19' and prod.edate >='2020-09-19')) and prod.cateid=83 order by cate.seq asc,prod.seq desc
|
|
|
|
|
|
|
|
|
1 | 2 |
 |
|
|
