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 q.QPInc,q.CustKind,q.CustID,q.ServiceID,q.VenID,q.MemID,q.Kname,q.MallID,q.ProdKind,q.ProdInc,q.Ccode1,q.Ccode2,q.Ccode3,q.Ccode4,q.BrandID,q.Pname,Pimg=convert(text,q.Pimg),q.Lrprice,q.Srprice,q.Qkind,q.Title,Question=convert(text,q.Question),Answer=convert(text,q.Answer),q.ClickCnt,q.SMSYes,q.SecretYes,q.Stock,q.AnswerYes,q.AnswerFile1,q.AnswerDate,q.AnswerDate8,q.File1,q.DeleteYes,q.CreateDate,q.CreateDate8,q.CreateOper,q.ModifyDate,q.ModifyDate8,q.ModifyOper,q.Pass ,q.GongjiYes, p.PMInc from psQnAProd q left join (select PMInc , ProdKind, ProdInc from psProdMain) p on q.ProdKind=p.ProdKind and q.ProdInc=p.ProdInc where QPInc not in (select top 0 QPInc from psQnAProd where 1=1 and DeleteYes=0 and ViewYes=1 order by QPInc Desc ) and DeleteYes=0 and ViewYes=1 order by GongjiYes Desc, QPInc Desc
이미지 상품정보 내 용 문의일자