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(1025)) ORDER BY Porder,Pmakat
|
Compressors
|
|
compressor, air compressor,
AC compressor, compressor parts,
compressors, compressor de ar,
compressor oil, air compressor parts, pressurizing air, compressed air supply system,
compressed air supplt, lab compressor, loboratory compressor, oil free compressor,
silent compressor, oil free air compressor,
|
|