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



select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='LemonAdminImg'
select LCInc,CustKind,CustID,ServiceID,VenID,LMID,Contents=convert(text,Contents),WriteYes,ReplyYes,ModifyYes,DelYes,OpenYes,KindYes,Kind,UploadYes,UserIDYes,KnameYes,HashYes,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psLemonConfig where LMID ='gallery'
select top 20 m.LMInc,CustKind,CustID,ServiceID,VenID,LMDInc,LMID,MemID,MemYes,Writer,Title,Contents,Kind,AnswerYes,SecretYes,SercretPwd,FileYes,ViewYes,GongjiYes,Score,ClickCnt,Price,AddInfo1,AddInfo2,OMInc,DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper, ReplyCount from psLemonMain m left join (select LMInc,ReplyCount=count(LRInc) from psLemonReply where DeleteYes=0 group by LMInc) r on m.LMInc = r.LMInc where m.LMInc not in (select top 0 LMInc from psLemonMain where DeleteYes=0 and LMID='gallery' and ViewYes=1 order by GongjiYes Desc , Score Desc , LMInc Desc ) and DeleteYes=0 and LMID='gallery' and ViewYes=1 order by GongjiYes Desc , Score Desc , m.LMInc Desc
부터 까지
    검색어
번호 글제목 답변 작성일