Select A.* From ( Select * From ( Select Row_Number() Over ( Order By MAX(A.ProductRegDate) DESC ) As RowNo, A.ProductNo, A.ProductStyle, A.ProductName, A.ProductName_kor, A.ProductPriceSale , Z.TAG_image, Z.TAG_NAME, Z.Color_name, Z.ColorProduct_No From VW_ProductList As A Left Outer Join VW_ProductCategoryNo As B On A.ProductNo = B.ProductNo Left Join TB_Product_BatchCount As C On A.ProductNo = C.ProductNo Inner Join VW_ProductOption_Cols As Z On A.ProductNo = Z .ProductNo Where A.CodeProductStatusNo = 1 And A.p_type Not In ( 99 ) And ( CategoryNo1 = ? Or CategoryNo2 = ? Or CategoryNo3 = ? ) Group By A.ProductNo, A.ProductStyle, A.ProductName, A.ProductName_kor, A.ProductPriceSale , Z.TAG_image, Z.TAG_NAME, Z.Color_name, Z.ColorProduct_No ) As Cte Where RowNo between (1 - 1) * 16 + 1 and 1 * 16 ) As A
