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 40, 20
Cosmetic packaging
Product
N3 608
Capacity : 30 ml
Type : Dispenser
Material
Cap : ABS
Pump : PP
Bottle : PET
N3 608-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : ABS
Pump : PP
Bottle : PET
N3 414A
Capacity : 50 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 344S
Capacity : 30 ml
Type : Airless
Material
Cap: PP / PETG
Pump: PP
Bottle: PP / PETG
Base: PETG
N3 344-1
Capacity : 50 ml
Type : Airless
Material
Cap: PP / PETG
Pump: PP
Bottle: PP / PETG
Base: PETG
N3 174-1H
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : PETG
Base : ABS / SAN
N3 173-1H
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Button : PP
Shoulder : ABS
Inner Bottle : PP
Outer Bottle : PETG
Base : ABS / SAN
N4 122
Capacity : 30 ml
Type : Cream Jar
Material
Cap : PMMA / ABS
Lid : PE
Inner Jar : PP
Outer Jar : PMMA
N4 123
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PMMA / ABS
Lid : PE
Inner Jar : PP
Outer Jar : PMMA
N3 101-3
Capacity : 130 ml
Type : Dispenser
Material
Cap : PCTA/PETG
Pump : PP/AL
Shoulder : ABS
Inner Bottle : PCTA/PETG
Outer Bottle : PMMA
N3 101
Capacity : 130 ml
Type : Screw Bottle
Material
Outer Cap : PMMA
Middle Cap : ABS
Inner Cap : PP
Shoulder : ABS
Inner Bottle : PCTA
Outer Bottle : PMMA
N3 100
Capacity : 40 ml
Type : Dispenser
Material
Cap : PMMA
Pump : PP/AL.
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : PMMA
N3 016S
Capacity : 100 ml
Type : Airless
Material
Over Cap: PETG/ABS
Actuator : PP / AL.
Shoulder : ABS
Bottle : SAN / PETG
Base : ABS
N3 014S
Capacity : 60 ml
Type : Airless
Material
Over Cap: PETG/ABS
Actuator : PP / AL.
Shoulder : ABS
Bottle : SAN / PETG
Base : ABS
N2 124
Capacity : 4 ml
Type : Pallet
Material
Cover : ABS
Insert : ABS
N1 229SQ
Capacity : 15 ml
Type : Compact (with 1.5g Stick)
Material
Outer Case : ABS
Lid : PP
Inner Case : PE
Button : PC
Stick : SAN
Stick Cap : K-resin
N1 229M
Capacity : 15 ml
Type : Compact (mesh)
Material
Outer Case : ABS
Inner cover : PP
Inner Case : PE
Mid-Ring : PP
N1 229A
Capacity : 15 ml
Type : Compact
Material
Cap : ABS
Lid : PP
Frame : PP
Inner case : PE
Button : PC
Base : ABS
N1 229-2
Capacity : 9 ml
Type : Compact
Material
Cap : ABS
Lid : PP
Frame : PP
Inner case : PE
Base : PETG
N1 229-1
Capacity : 15 ml
Type : Compact
Material
Cap : ABS
Lid : PP
Frame : PP
Inner case : PE
Base : PETG
Download
Catalog