염모제(헤나,칼라앰플,탈색제,리무버)
-
Select Top 100 * from shop_item_list a, shop_prdt_info b where a.it_code = b.it_code and status in ('Y') and a.it_code not in (select top 0 a.it_code from shop_item_list a, shop_prdt_info b where a.it_code = b.it_code and status in ('Y') and left(categorycode,3)='002' order by DISPLAY_SEQ_CATE1) and left(categorycode,3)='002' order by DISPLAY_SEQ_CATE1
-
H2O 칼라 앰플 8ml￦2,000
색상선택
