select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='MemPointViewType'
뉴욕매니아 - 패션피플의 선택!! 글로벌쇼핑 넘버원



공지사항
상품문의
구매후기
직거래장터
select RMInc,CustKind,CustID,ServiceID,VenID,MallID,BrandID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,Pname,Purl,convert(text,Pimg) as Pimg,Lrprice,Srprice,Stock,ColorTxt,SizeTxt,SecretYes,SizeViewYes,Height,Weight,FootSize,Chest,Waist,Img1,Img2,Img3,Img4,Img5,Img6,Img7,Img8,Img9,Img10,MemID,MemYes,OMInc,OrderCode,OIInc,Grade,Score,Title,ReviewTxt=convert(text,ReviewTxt),GongjiYes,ViewYes,ClickCnt,AnswerYes,AnswerTitle,AnswerTitle,Answer=convert(text,Answer),AnswerDate8,DeleteYes,CreateDate,CreateDate8,ModifyDate,ModifyDate8,ModifyOper from psReviewMain where DeleteYes=0 and ViewYes=1 and GongjiYes=1 order by Score desc , RMInc desc
SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by Score desc, RMInc Desc) RNUM, RMInc,CustKind,CustID,ServiceID,VenID,MallID,BrandID,ProdKind,ProdInc,Ccode1,Ccode2,Ccode3,Ccode4,Pname,Purl,convert(text,Pimg) as Pimg,Lrprice,Srprice,Stock,ColorTxt,SizeTxt,SecretYes,SizeViewYes,Height,Weight,FootSize,Chest,Waist,Img1,Img2,Img3,Img4,Img5,Img6,Img7,Img8,Img9,Img10,MemID,MemYes,OMInc,OrderCode,OIInc,Grade,Score,Title,ReviewTxt=convert(text,ReviewTxt),GongjiYes,ViewYes,ClickCnt,AnswerYes,AnswerTitle,Answer=convert(text,Answer),AnswerDate8,DeleteYes,CreateDate,CreateDate8,ModifyDate,ModifyDate8,ModifyOper FROM psReviewMain where DeleteYes=0 and ViewYes=1 and GongjiYes=0 ) A WHERE RNUM BETWEEN ((1-1) * 10) + 1 AND 1*10
번호 상품정보 제목 작성자 작성일