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 140, 20
Cosmetic packaging
Product
N4 534-3
Capacity : 100 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 534-2
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 534-1
Capacity : 30 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N4 534-1R
Capacity : 30 ml
Type : Cream Jar
Material
Cap : PP
Lid : LDPE
Inner Jar : PP
Outer Jar : PP
N3 629-1
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Pump : PP/AL.
Bottle : PETG
Base : ABS
N3 629
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Pump : PP/AL.
Bottle : PETG
Base : ABS
N3 469-1
Capacity : 50 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 469
Capacity : 30 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 440-3A
Capacity : 150 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440-2A
Capacity : 120 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440-1A
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440A
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 391S
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN
Base : ABS
N3 440-3
Capacity : 150 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440-2
Capacity : 120 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440-1
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 440
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Actuator : PP
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 384R
Capacity : 30 ml
Type : Airless (Refillable)
Material
Button : PP/PETG
Pump : PP
Inner Bottle : PP
Outer Bottle : PETG
Base : ABS
N3 385R-1
Capacity : 130 ml
Type : Dispenser (Refillable)
Material
Button : PP/PETG
Pump : PP
Inner Bottle : PETG
Outer Bottle : PETG
Base : ABS
N3 319-1
Capacity : 50 ml
Type : Airless
Material
Cap : PP/PETG/ABS
Pump : PP
Inner Bottle : PP
Outer Bottle : SAN
Download
Catalog