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='4' and Ccode2='21' ) 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=4) or (Depth=3 and Ccode1=4 and Ccode2=21 )) order by CBInc asc
전체
exec psDisplayConf_List_Display 'cate', 'S1', '4', '21', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S2', '4', '21', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S3', '4', '21', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'S4', '4', '21', '0', '0', '' , 0
exec psDisplayConf_List_Display 'cate', 'J1', '4', '21', '0', '0', '' , 0
0 상품
 
검색된 상품이 없습니다.