SELECT a.idx, b.prd20, a.prd_cn_Name FROM nPrdInfo a left outer join nPrdInfoadd b ON a.idx = b.idx WHERE 1 AND length(a.prdCode) = '3' and b.hView = 'Y' AND b.hKind in ('B','C') order by a.idx desc
主要产品
  |   회원가입  |   쇼핑몰