select ROW_NUMBER() OVER (order by products.Porder,Pmakat ) as RowNumber, isnull(PWeight,0) as PWeight, isnull(Pscreen,0) as Pscreen,isnull(Pmemory,0)as Pmemory,isnull(Pdisk,0)as Pdisk,Pname,PnameEN,PID,Pmakat,Pprice,PCprice,POprice from [productsView] as products where (Ponline = 1) AND PID IN (Select PID from productCategory where PcatID in(7019)) ORDER BY Porder,Pmakat
7x5pjg85n8|0010220FE5AD|Pcat|CategoryDescEN|CA2FFD91-D3F6-44F5-8437-DB11297AFB7A
|