쇼핑몰   Q&A     REVIEW     PHOTO ZONE     EVENT     SALE ON
COMMUNITY
공지사항
상품문의
구매후기
포토후기
자유게시판
SELECT * FROM ( SELECT ROW_NUMBER() OVER (order by ) 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
번호 상품정보 제목 작성자 작성일
가입사실확인