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 product.viewYn in (1,3) ORDER BY registdate desc LIMIT 200, 20
Cosmetic packaging
Product
N3 545
Capacity : 30 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP
Bottle : HDPE
N3 515M
Capacity : 120 ml
Type : Dispenser
Material
Cap : PETG/ABS
Pump : PP/AL.
Inner Bottle : PETG
Outer Bottle : SAN/PETG
N3 514M
Capacity : 50 ml
Type : Airless
Material
Cap : PETG/ABS
Pump : PP/AL.
Inner Bottle : PP
Outer Bottle : SAN/PETG
N3 450-1G
Capacity : 130 ml
Type : Dispenser
Material
Cap : PETG
Actuator : PP + AL.
Shoulder : ABS
Bottle : PET
N3 445-3
Capacity : 120 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Shoulder : ABS
Outer bottle : PETG
Inner bottle : PP
N3 445-2
Capacity : 40 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Shoulder : ABS
Outer bottle : PETG
Inner bottle : PP
N3 445-1
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Shoulder : ABS
Outer bottle : PETG
Inner bottle : PP
N3 445
Capacity : 15 ml
Type : Airless
Material
Cap : PETG
Pump : PP
Shoulder : ABS
Outer bottle : PETG
Inner bottle : PP
N3 425-2
Capacity : 120 ml
Type : Dispenser
Material
Cap : SAN
Pump : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 425-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : SAN
Pump : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 425
Capacity : 40 ml
Type : Airless
Material
Cap : SAN
Pump : ABS
Inner Bottle : PP
Outer Bottle : SAN
N3 264R
Capacity : 120 ml
Type : Dispenser
Material
Cap : SAN / ABS / PETG
Pump : ABS
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 263R
Capacity : 50 ml
Type : Dispenser
Material
Cap : SAN / ABS / PETG
Pump : ABS
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 264
Capacity : 120 ml
Type : Dispenser
Material
Cap : SAN / ABS / PETG
Pump : ABS
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 263
Capacity : 50 ml
Type : Dispenser
Material
Cap : SAN / ABS / PETG
Pump : ABS
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N3 146
Capacity : 100 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN / PETG
N3 145
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN / PETG
N3 144-1
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN / PETG
N3 144
Capacity : 40 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN / PETG
N2 145
Capacity : 9 ml
Type : Pallet
Material
Cover : ABS
Button : ABS
Insert: EVA
Case : ABS
Download
Catalog