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' || a.idx in ('171','172','173')) and b.hView = 'Y' AND b.hKind = 'E' order by a.idx desc
主要产品
  |   회원가입  |   쇼핑몰