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(1005)) ORDER BY Porder,Pmakat
|
Air Purify
|
|
Air purifier is an air purification equipment with advanced
level , widely used in hospital, small clinic, laboratory, office,
meeting room and home etc. It can protect your life and
your health through purifying dust , germ and virus, etc in the
air.
Air Purify, Air Purifier.
|
Code: AIRP-130
|
2.58
|
|
|
0.90
|
|
|
1.14
|
|
|
200.00
|
|
+
|
|
Code: AIRP-210
|
2.58
|
|
|
0.90
|
|
|
1.14
|
|
|
200.00
|
|
+
|
|
|