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 ='DefaultOrderTypeList'
SELECT * FROM ( SELECT ROW_NUMBER() OVER ( order by PMInc desc ) RNUM, * FROM psProdList where 1=1 and BrandID='coach' ) A WHERE RNUM BETWEEN ((1-1) * 40) + 1 AND 1*40
select BMInc,CustKind,CustID,ServiceID,Brand,BrandID,ProdCnt,ProdCntB,BestYes,ViewYes,LeftTitleImg,MainBanner,DeleteYes,CreateDate8,CreateOper,ModifyDate8,ModifyOper,DesignHtml from psBrandMain where BrandID = 'coach'
select * from psBrandCateBatch where BrandID = 'coach' order by Pos1_c desc, Pos2_c desc, Pos3_c desc, Pos4_c desc, CMInc
coach
coach
exec psDisplayConf_List_Display 'brand', 'J1', '0', '0', '0', '0', 'coach' , 0
exec psDisplayConf_List_Display 'brand', 'J10', '0', '0', '0', '0', 'coach' , 0
0 상품
 
검색된 상품이 없습니다.