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



select top 10 AMInc,CustKind,CustID,ServiceID,VenID,MemID,AMOrderCode,TotalSprice,TotalWeightEx,TotalEprice,TotalEweight,DpayYes,TotalEpriceD,TotalEweightD,CustMemo=convert(text,CustMemo),DeliMemo=convert(text,DeliMemo),AdminMemo=convert(text,AdminMemo),EpriceMemo=convert(text,EpriceMemo),Estep,Eyes,AllBuyYes,LocalTax,LocalDeliveryFee,AddFee1,AddFee2,Profit,DeliveryFee,Custom,AddTax,DeliveryFeeEx,CustomEx,AddTaxEx,BundleFee,EntryFee,EntryStoreFee,Akind,Title,Contents,GongjiYes,ViewYes,Score,AgencyType,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psAgencyBuyMain where AMInc not in (select top 0 AMInc from psAgencyBuyMain where 1=1 and ViewYes=1 and GongjiYes=0 and AgencyType = 'BUY' order by GongjiYes desc, Score desc , AMInc desc ) and ViewYes=1 and GongjiYes=0 and AgencyType = 'BUY' order by GongjiYes desc, Score desc , AMInc desc
select AMInc,CustKind,CustID,ServiceID,VenID,MemID,AMOrderCode,TotalSprice,TotalWeightEx,TotalEprice,TotalEweight,DpayYes,TotalEpriceD,TotalEweightD,CustMemo=convert(text,CustMemo),DeliMemo=convert(text,DeliMemo),AdminMemo=convert(text,AdminMemo),EpriceMemo=convert(text,EpriceMemo),Estep,Eyes,AllBuyYes,LocalTax,LocalDeliveryFee,AddFee1,AddFee2,Profit,DeliveryFee,Custom,AddTax,DeliveryFeeEx,CustomEx,AddTaxEx,BundleFee,EntryFee,EntryStoreFee,Akind,Title,Contents,GongjiYes,ViewYes,Score,AgencyType,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psAgencyBuyMain where 1=1 and ViewYes=1 and GongjiYes=1 and AgencyType = 'BUY' order by GongjiYes desc, Score desc , AMInc desc
쿠폰
견적게시판
견적번호 신청자 제목 견적종류 견적상태 견적신청일
신청된 견적이 없습니다. 셀프 쇼핑 후 견적신청을 해주세요.