select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='MemPointViewType'
select BMInc,CustKind,CustID,ServiceID,Brand,BrandID,ProdCnt,ProdCntB,BestYes,ViewYes,LeftTitleImg,MainBanner,DeleteYes,CreateDate8,CreateOper,ModifyDate8,ModifyOper,DesignHtml from psBrandMain where BrandID = 'Sea-Doo' select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='DefaultOrderTypeList' query error!
홈
브랜드몰
Sea-Doo
Sea-Doo
select
*
from
psBrandCateBatch
where
BrandID = 'Sea-Doo'
order by
Pos1_c desc,
Pos2_c desc,
Pos3_c desc,
Pos4_c desc,
CMInc
select CMInc,CustKind,CustID,ServiceID,VenID,SetType,Value=convert(text,Value),DeleteYes,CreateDate,CreateDate8,CreateOper,ModifyDate,ModifyDate8,ModifyOper from psSetMain where SetType ='BrandListLimitRcnt'
select
Brand=max(Brand), BrandID,ViewYes=max(ViewYes),BestYes=max(BestYes),Cnt=sum(Cnt),
BrandKor= max(BrandKor)
from psBrandMainBatch
where
ViewYes=1
and Rcnt >= 1
group by BrandID
order by BrandID