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 Ccode1='34' ) A WHERE RNUM BETWEEN ((1-1) * 40) + 1 AND 1*40
select * from psCateMainBatch where 1=1 and (Depth=1 or ( Depth=2 and Ccode1=34) ) order by CBInc asc
전체
exec psDisplayConf_List_Display 'cate', 'S1', '34', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S2', '34', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S3', '34', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S4', '34', '0', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'J1', '34', '0', '0', '0', '' , 0
0 상품
 
검색된 상품이 없습니다.