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(7069)) ORDER BY Porder,Pmakat
Code: TEPS-4
|
0.00
|
|
|
0.00
|
|
|
0.00
|
|
|
0.00
|
|
+
|
|
Code: TEPS-V-6
|
0.00
|
|
|
0.00
|
|
|
0.00
|
|
|
0.00
|
|
+
|
|
|