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(7004)) ORDER BY Porder,Pmakat
|
Dry Block Heaters
|
Dry Block HeatersFried electric manufactures high-quality and professional Dry Block Heaters for various uses.They are great for applications that require temperature stability.
|
|