|   
Home    |    Contact Us    |    Service Center    |    Customer
Filter by :
Type






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(1122)) ORDER BY Porder,Pmakat
Code: BD-1
0.00 | 0.00 | 0.00 | 0.00
+
Code: DigiRock-HR1
0.87 | 0.46 | 0.62 | 120.00
+
Code: DigiRock-MR2
0.87 | 0.46 | 0.62 | 120.00
+
Code: GS-743G
0.00 | 0.00 | 0.00 | 0.00
+
Code: GSD-754K
0.00 | 0.00 | 0.00 | 0.00
+
Code: UHT-300
0.00 | 0.00 | 0.00 | 0.00
+
Code: ShoreA
0.00 | 0.00 | 0.00 | 0.00
+
Code: ShoreC
0.00 | 0.00 | 0.00 | 0.00
+
Code: ShoreD
0.00 | 0.00 | 0.00 | 0.00
+
Code: HLX-AC
0.00 | 0.00 | 0.00 | 0.00
+
Code: HLX-D
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-680
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-607B
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-610
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-701N
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-753G
0.00 | 0.00 | 0.00 | 0.00
+
Code: GS-754G
0.00 | 0.00 | 0.00 | 0.00
+
Code: GSD-719
0.00 | 0.00 | 0.00 | 0.00
+
Code: GSD-719H
0.00 | 0.00 | 0.00 | 0.00
+
Code: GSD-719L
0.00 | 0.00 | 0.00 | 0.00
+
Code: GSD-720
0.00 | 0.00 | 0.00 | 0.00
+
Code: MH180
0.00 | 0.00 | 0.00 | 0.00
+
Code: MH210
0.00 | 0.00 | 0.00 | 0.00
+
Code: MH310
0.00 | 0.00 | 0.00 | 0.00
+
Code: MH320
0.00 | 0.00 | 0.00 | 0.00
+
Code: UHT-100
0.00 | 0.00 | 0.00 | 0.00
+
Code: SHR-150ED
0.00 | 0.00 | 0.00 | 0.00
+
Code: SHR-150M
0.00 | 0.00 | 0.00 | 0.00
+
Code: SHB-3000E
0.00 | 0.00 | 0.00 | 0.00
+
Code: SHR-150D
0.00 | 0.00 | 0.00 | 0.00
+
   |   
Home      |      Contact Us
Service Center      |      Customer