|
|
|
 
 
 
 



|
|
|
|
SELECT a.productcode,a.vender,a.kgprice,a.brand,a.madein, a.productname, a.sellprice, a.icetype, a.expiredate, a.quantity, a.reserve, a.reservetype, a.production, IF(a.quantity<=0,'0','1') as date2, a.tinyimage, a.etctype, a.option_price, a.consumerprice, a.tag, a.selfcode, a.userspec FROM tblproduct AS a LEFT OUTER JOIN tblproductgroupcode b ON a.productcode=b.productcode WHERE 1=1 AND a.display!='N' AND a.event2='Y' AND a.productcode LIKE '051002%' AND (a.group_check='N' OR b.group_code='') ORDER BY date2 DESC, a.kgprice asc LIMIT 0, 100
| |
| |
| |
|
|
|
|
|
|
|
|
1 |
|
|