select product.* , attacheFiles.filename as listfilename , attacheFiles.filename_org as listfilename_org , attacheFiles.filename_alt as listfilename_alt from product left outer join attacheFiles on product.no = attacheFiles.common_fk and attacheFiles.tablename = 'product' and concat(attacheFiles.fileobject,attacheFiles.filename_index) = 'imagename1' where 1 = 1 AND categoryFk REGEXP("20211013nm04ghezhr") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 20, 20
Cosmetic packaging
Product
N6 172-30OSP (Paper Tube)
Capacity : 50 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-25SP (Paper Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-35SP (Paper Tube)
Capacity : 45 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-45FP (Paper Tube)
Capacity : 120 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N4 614-1
Capacity : 50 ml
Type : Cream Jar
Material
Cap : Aluminum
Gasket : PE (removable)
Lid : PP
Jar : Glass
N5 329 (DDL)
Capacity : 5 ml
Type : Dial Dual (2.8ml+2.8ml)
Material
Cap : PETG
Applicator : TPE
Shoulder : PP
Bottle : PETG
Base : ABS
N3 454E (DMP)
Capacity : 10 ml
Type : Dispenser (9ml+1ml Dual Mix)
Material
Cap : PETG/ABS
Pump : PP/AL
Shoulder : ABS
Bottle : PETG
Base : ABS
N4 613
Capacity : 50 ml
Type : Cream Jar (Refillable)
Material
Cap : PETG
Shoulder : PP
Inner Jar : PP
Outer Jar : Glass
N3 605-1 (TNA)
Capacity : 50 ml
Type : Airless
Material
Pump Cover : ABS
Neck : PP
Inner Bottle : PP
Outer Bottle : ABS
N6 282-2 (TOD)
Capacity : 40 ml
Type : Tottle Dropper
Material
Cap : PET
Nozzle : PET
Shoulder : PP
Body : LDPE+EVOH (PCR available)
N6 282-1 (TOD)
Capacity : 25 ml
Type : Tottle Dropper
Material
Cap : PET
Nozzle : PET
Shoulder : PP
Body : LDPE+EVOH (PCR available)
N6 282 (TOD)
Capacity : 20 ml
Type : Tottle Dropper
Material
Cap : PET
Nozzle : PET
Shoulder : PP
Body : LDPE+EVOH (PCR available)
N3 632 (EL GLASS)
Capacity : 20 ml
Type : Dispenser
Material
Button : ABS
Pump Cover : ABS
Bottle : Glass
N3 632-1 (EL GLASS)
Capacity : 30 ml
Type : Dispenser
Material
Button : ABS
Pump Cover : ABS
Bottle : Glass
N3 632-2 (EL GLASS)
Capacity : 50 ml
Type : Dispenser
Material
Button : ABS
Pump Cover : ABS
Bottle : Glass
N6 017P (Paper Tube)
Capacity : 30 ml
Type : Airless Tube
Material
Cap : ABS/PETG
Pump : PP/AL
Tube : Paper/PE Laminated
N3 605 (TNA)
Capacity : 30 ml
Type : Airless
Material
Pump Cover : ABS
Neck : PP
Inner Bottle : PP
Outer Bottle : ABS
Download
Catalog