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 0, 20
Cosmetic packaging
Product
N4 611-1 (OCR)
Capacity : 50 ml
Type : Cream Jar (Refillable)
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 611 (OCR)
Capacity : 30 ml
Type : Cream Jar (Refillable)
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N6 172-25SSP (White Paper Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-30FP (White Paper Tube)
Capacity : 50 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N6 172-50FP (White Paper Tube)
Capacity : 180 ml
Type : Tube
Material
Cap : PP (PCR Available)
Tube : Paper + PE
N3 546 (DAC)
Capacity : 15 ml
Type : Compact (Airless)
Material
Outer Case : ABS
Button : PCTA
Plate : POK
Inner Case : PP
Piston : HDPE
Base : PP
N3 454 (DMP)
Capacity : 10 ml
Type : Dispenser (9ml+1ml Dual Mix)
Material
Cap : PETG
Pump : PP/AL
Shoulder : ABS
Bottle : PETG/SAN
Base : ABS
Plug : PP
N6 172-30FMP (Mono PE Tube)
Capacity : 30 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-25SMP (Mono PE Tube)
Capacity : 15 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-40FMP (Mono PE Tube)
Capacity : 100 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N6 172-45FMP (Mono PE Tube)
Capacity : 150 ml
Type : Tube
Material
Cap : PE
Head : PE
Tube : PE / Bio based PE
N3 637-4
Capacity : 15 ml
Type : Airless/Dispenser
Material
Cap : PP
Pump : PP (Metal-free)
Inner Bottle : PP
Outer Bottle : Glass
N3 637-1
Capacity : 20 ml
Type : Airless/Dispenser
Material
Cap : PP
Pump : PP (Metal-free)
Inner Bottle : PP
Outer Bottle : Glass
N3 637-2
Capacity : 30 ml
Type : Airless/Dispenser
Material
Cap : PP
Pump : PP (Metal-free)
Inner Bottle : PP
Outer Bottle : Glass
N3 637-3
Capacity : 50 ml
Type : Airless/Dispenser
Material
Cap : PP
Pump : PP (Metal-free)
Inner Bottle : PP
Outer Bottle : Glass
N4 330N
Capacity : 50 ml
Type : Cream Jar (Grinding Type)
Material
Cap : PETG
Dial : PP
Shoulder : PETG
Inner Jar : PP
Outer Jar : PETG
N3 640
Capacity : 30 ml
Type : Airless (Metal-Free)
Material
Cap : PP
Pump : PP (metal-free)
Bottle : PP
Piston : PP
N3 658-1
Capacity : 30 ml
Type : Airless (Metal-Free)
Material
Cap : PP
Pump : PP (metal-free)
Bottle : PP
Piston : PP
N3 640-1
Capacity : 50 ml
Type : Airless (Metal-Free)
Material
Cap : PP
Pump : PP (metal-free)
Bottle : PP
Piston : PP
N3 658
Capacity : 15 ml
Type : Airless (Metal-Free)
Material
Cap : PP
Pump : PP (metal-free)
Bottle : PP
Piston : PP
Download
Catalog