SELECT top 10 ProductID,ProductNo,ProductName,ProductName1,Spec,Spec1,Description,Remark,IsDisplay,Hot,ItemNo,IsNSP,Introduction,Introduction1,isMain,TypeName,TypeName1,TypeNo,ProductTypeID,FilePath FROM dbo.T_ProductType_Product_VIEW WHERE ProductTypeID=1660 AND (ProductID NOT IN (SELECT TOP (10*(1-1)) ProductID FROM dbo.T_ProductType_Product_VIEW WHERE ProductTypeID=1660 order by ProductNo)) ORDER BY ProductNo
6502-CA-80CP
玻璃盆襯墊組
6502-CB-80CP
長水塞套圈
6502-CD-80CP
長水塞套圈
6502-CF-80CP
長水塞套圈