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 120, 20
Cosmetic packaging
Product
N3 630
Capacity : 35 ml
Type : Airless
Material
Cap : PETG/ABS
Pump: PP/AL
Shoulder: ABS
Inner Bottle : PETG
Outer bottle: SAN
N4 609
Capacity : 50 ml
Type : Cream Jar
Material
Cap : ABS/PP
Lid : LDPE
Inner jar : PP
Outer Jar : SAN
N4 609-1
Capacity : 150 ml
Type : Screw Bottle
Material
Cap : ABS/PP
Reducer: LDPE
Bottle : PETG
N3 341-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner bottle : PETG
Outer bottle : PMMA
N3 340-1
Capacity : 35 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner bottle : PETG
Outer bottle : PMMA
N3 339-1
Capacity : 25 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP/AL.
Shoulder : ABS
Inner bottle : PETG
Outer bottle : PMMA
N4 415
Capacity : 30 ml
Type : Cream Jar
Material
Outer cap : ABS
Inner cap : PP
Inner jar : PP
Outer cap : PMMA
N4 415-1
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : ABS
Inner cap : PP
Inner jar : PP
Outer cap : PMMA
N3 506
Capacity : 150 ml
Type : Dispenser
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : PMMA
N3 505
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Inner bottle : PP
Outer bottle : PMMA
N4 523
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap: ABS
Inner cap : PP
Lid : LLDPE
Inner Jar : PP
Outer Jar : PMMA
N4 523-1
Capacity : 30 ml
Type : Cream Jar
Material
Outer cap: ABS
Inner cap : PP
Lid : LLDPE
Inner Jar : PP
Outer Jar : PMMA
N3 483-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : PETG
N3 483
Capacity : 150 ml
Type : Dispenser
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : PETG
N4 541
Capacity : 400 ml
Type : Cream Jar
Material
Cap : PP/ABS
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 540
Capacity : 300 ml
Type : Cream Jar
Material
Cap : ABS/PP
Lid : LDPE
Inner Jar : PP
Outer Jar : ABS
N4 539-2
Capacity : 250 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Jar : PP
N4 537
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 534-4
Capacity : 200 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 534
Capacity : 10 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
Download
Catalog