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



select PMInc,CustKind,CustID,ServiceID,VenID,Ptype,ImgYes,PopName,PopContents=convert(text,PopContents),Width,Height,PTop,PLeft,ViewYes,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,LinkUrl,LinkTarget from psPopupMain where DeleteYes=0 and ViewYes=1 order by PMInc desc
select top 5 NAInc,CustKind,CustID,ServiceID,VenID,MemID,Nkind,Title,Notice,File1,File2,ClickCnt,Score,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,subject_style , subject_color ,subject_size from psNoticeAdmin where DeleteYes=0 order by Score Desc , NAInc Desc
등록된 공지사항이 없습니다.
exec psDisplayConf_List_Display 'main', 'S20', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S21', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S22', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S23', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S24', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S25', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S26', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S27', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S28', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S29', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S30', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S31', '0', '0', '0', '0', '' , 0
select top 5 NAInc,CustKind,CustID,ServiceID,VenID,MemID,Nkind,Title,Notice,File1,File2,ClickCnt,Score,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,subject_style , subject_color ,subject_size from psNoticeAdmin where DeleteYes=0 order by Score Desc , NAInc Desc
등록된 공지사항이 없습니다.
select top 3 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=0 order by Score desc , Grade desc, RMInc desc