select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='MemPointViewType'
구매대행 쇼핑몰 - PansyMall
  Q&A     REVIEW     PHOTO ZONE     EVENT     SALE ON
select * from psCateMainBatch where 1=1 and (Depth=1 or Depth=2) order by CBInc asc
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 BMInc,CustID,Pkind,Dkind,BannerImg,LinkUrl,LinkTarget,BannerDesc,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psBannerMain where Pkind='etc' and Dkind='banner1' and ViewYes=1
select BMInc,CustID,Pkind,Dkind,BannerImg,LinkUrl,LinkTarget,BannerDesc,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psBannerMain where Pkind='etc' and Dkind='banner2' and ViewYes=1
select BMInc,CustID,Pkind,Dkind,BannerImg,LinkUrl,LinkTarget,BannerDesc,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psBannerMain where Pkind='etc' and Dkind='banner3' and ViewYes=1
select BMInc,CustID,Pkind,Dkind,BannerImg,LinkUrl,LinkTarget,BannerDesc,ViewYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psBannerMain where Pkind='etc' and Dkind='banner4' and ViewYes=1
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', 'J1', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S1', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S2', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S3', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S4', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S5', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S6', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S7', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S8', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S9', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S1', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S2', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S3', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S4', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S5', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S6', '0', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'main', 'S7', '0', '0', '0', '0', '' , 0
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
등록된 상품리뷰가 없습니다.
가입사실확인