코스모스벽지

Product

Brand	SOHO MODERN TETRA NOVUS
Color
Pattern	FABRIC CONCRETE FLOWER TREE DOT SQUARE STRIPE DAMASK ETC
Style	MODERN NATURAL CLASSIC ORIENTAL ELEGANCE KIDS
Product No.

select count(*) as cnt from ( select pd.* , ca1.wm_ca_id as ca_id1 , ca2.wm_ca_id as ca_id2 , ca3.wm_ca_id as ca_id3 from sp_product as pd left join sp_category as ca1 on pd.wm_ca_id1 = ca1.wm_id left join sp_category as ca2 on pd.wm_ca_id2 = ca2.wm_id left join sp_category as ca3 on pd.wm_ca_id3 = ca3.wm_id ) as product where 1 = 1 and product.wm_use = 'Y'
• 
  70116-2
• 
  70116-3
• 
  70116-4
• BEST
  
  70117-1
• BEST
  
  70117-2
• 
  70117-3
• 
  70117-4
• 
  70118-1
• 
  70118-2
• 
  70118-3
• 
  70118-4
• 
  70119-1
• 
  70119-2
• 
  70119-3
• 
  70119-4