SQL query error: SELECT p.ProductID, ProdnameE, ProdNameT , SizeW, SizeD,SizeH,PriceUnit,ColorNameE,MakerNameE,RankName,L,M,L_T,M_T,case when ifnull(PSTSH1.Shop1Qty,0) < 0 then 0 else ifnull(PSTSH1.Shop1Qty,0) end Shop1Qty, case when ifnull(PSTSH1.Shop1Qty,0) < 0 then PSTSH1.Shop2Qty+PSTSH1.Shop1Qty else ifnull(PSTSH1.Shop2Qty,0) end Shop2Qty,ProdCatGrpNo,ProdCatMdlNo,PriceNet FROM (select * from mstproduct_n where DelFlag=0 ) as p Left Join (select productid,sum(Shop1Qty) Shop1Qty,sum(Shop2Qty) Shop2Qty from ( select ProductID, case when ShopID=1 then AvailableQty else 0 end Shop1Qty, case when ShopID=2 then AvailableQty else 0 end Shop2Qty from PrgStock) as b group by productid ) PSTSH1 on p.ProductID=PSTSH1.ProductID WHERE ifnull(PSTSH1.Shop2Qty,0)+ifnull(PSTSH1.Shop1Qty,0) > 0 AND ProdCatGrpNo = 14 ORDER BY PriceUnit ASC,p.ProductID ASC Limit 0,20
พรม｜สำนักงานตลาดแฮปปี้ไทยแลนด์