select * from ( SELECT ROW_NUMBER() OVER ( order by PMInc desc ) as RNUM, * FROM ( SELECT B.DeleteYes,B.Brand, L.* FROM psProdList as L WITH (NOLOCK) INNER JOIN psProdMain as B WITH (NOLOCK) ON L.PMInc = B.PMInc WHERE B.DeleteYes = 0 and B.ViewYes = 1 and B.Stock = 1 and B.Ccode1 != '67' and B.Ccode1='63' and B.BrandID='Levi's' ) A WHERE 1=1 ) AA WHERE RNUM BETWEEN ((1-1) * 40) + 1 AND 1*40
  
0 상품
검색된 상품이 없습니다.