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



select OMInc from psOrderMain where MemID='' and SuccessYes=0 and DeleteYes=0
select CMInc,CustKind,CustID,ServiceID,VenID,MemID,MemYes,SessionID,ProdKind,ProdInc,MallID,BrandID,Pname,ColorTxt,SizeTxt,OtherOpt,Lrprice,Srprice,DeliveryFee,Amount,SaveProd,SaveMem,OrderYes,ExpressYes,ExpressFee,COMInc,ProdCouponDcPrice,StockCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,TotalSrprice=(Srprice * Amount),Weight,MallKind from psCartMain where MemID='' and SessionID='e1da8c4ebd7c019f9941d684c90b29ae' and DeleteYes=0 order by CMInc desc
select CMInc,CustKind,CustID,ServiceID,VenID,MemID,MemYes,SessionID,ProdKind,ProdInc,MallID,BrandID,Pname,ColorTxt,SizeTxt,OtherOpt,Lrprice,Srprice,DeliveryFee,Amount,SaveProd,SaveMem,OrderYes,ExpressYes,ExpressFee,COMInc,ProdCouponDcPrice,StockCnt,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper,TotalSrprice=(Srprice * Amount),Weight,MallKind from psCartMain where MemID='' and SessionID='e1da8c4ebd7c019f9941d684c90b29ae' and DeleteYes=0 order by CMInc desc
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='VDeliveryFee'
select * from psCateMainBatch where 1=1 and (Depth=1 or Depth=2) order by CBInc asc
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='DcMainMultiApplyType'
select DMInc,CustKind,CustID,ServiceID,VenID,ScopeS,ScopeE,DC,SPriceYes,MPriceYes,BuyCnt,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psDCMain where ( ( SPriceYes=1 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=5 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=6 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=0 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=3 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=4 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=2 and ((0+1) % BuyCnt)=0 and (0+1) <> 0) ) and MPriceYes <> 2
select DMInc,CustKind,CustID,ServiceID,VenID,ScopeS,ScopeE,DC,SPriceYes,MPriceYes,BuyCnt,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psDCMain where ( ( SPriceYes=1 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=5 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=6 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=0 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=3 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=4 and ScopeS <= 0 and 0 <= ScopeE ) or ( SPriceYes=2 and ((0+1) % BuyCnt)=0 and (0+1) <> 0) ) and MPriceYes <> 2
이미지 상품코드 상품명 색상 사이즈 수량 상품가격 상품쿠폰할인 합계 회원적립
적립금총액 : 0 Point 주문상품 : 0 상품금액 : 0 배송비 : 0 상품총액 : 0
의류와 신발의 경우에는 $200(약25만원) 까지, 의류와 신발을 제외한 나머지 제품의 경우에는 15만원(고객결제금액)까지 한번의 배송비가 소요됩니다.
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayUse'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayShopName'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayShopID'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayKey'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayBtKey'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='NaverPayComonKey'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='DetailBimgSize'
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='DetailBimgSizeH'