코스모스벽지

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'
• 
  45219-4
• 
  45219-5
• 
  45219-6
• 
  45219-7
• 
  45218-1
• 
  45218-2
• 
  45218-3
• 
  45218-4
• 
  45216-1
• 
  45216-2
• 
  45215-1
• BEST
  
  45215-2
• 
  45215-3
• 
  45215-4
• 
  45206-1