SQL query error:SELECT count(*) FROM MstProduct p ,MstProdCat c,V_MstProdCat cat,MstColor cl,MstMaker mk,MstProductRank rk , MstMaterial Mrl,PrgStock PST, (SELECT p1.ProductId,pp2.SeqNo,ifnull(pp2.PictNameO,''),pp2.PictNameS,pp2.PictNameL,pp2.FileUpFlag,pp2.DelFlag FROM MstProduct p1 LEFT OUTER JOIN MstProductPict pp2 ON p1.ProductId=pp2.ProductId) pic WHERE p.ProdCat=c.ProdCatID and c.ProdCatID = cat.ProdCatID and ifnull(p.Color,0)=cl.ColorID and p.ProdMaker=mk.MakerID and ifnull(p.Material,0)=Mrl.MaterialID and ifnull(p.RankCur,1)=rk.RankID and p.ProductID=PST.ProductID and PST.LocationId = 1 and p.ProductID=ifnull(pic.ProductID,p.ProductID) and ifnull(pic.Seqno,1) = 1 and PST.AvailableQty > 0 and p.DelFlag=0 AND p.ProductID ='A0031477' ORDER BY p.ProductID  Product Detail

Japanese Japanese EnglistEnglish Thai Thai