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("20210928qqh7i9z8ef") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 140, 20
Cosmetic packaging
Product
N6 207-3
Capacity : 50 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207-2
Capacity : 200 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207-1
Capacity : 100 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 207
Capacity : 25 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N6 155-2
Capacity : 30 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N6 155-1
Capacity : 100 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N6 142
Capacity : 50 ml
Type : Roll-On
Material
Cap : PP
Ball : PP
Bottle : PE/Adhesive/EVOH
N4 585
Capacity : 50 ml
Type : Cream Jar
Material
Cap : PP
Lid : PP
Inner Jar : PP
Outer Jar : PP
N4 583
Capacity : 10 ml
Type : Cream Jar (5g+5g Dual)
Material
Jar : PETG
Ring : ABS
N4 483
Capacity : 120 ml
Type : Cream Jar
Material
Cap : PP
Lid : PE
Jar : PP
N4 382U
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap: ABS / SAN
Inner cap: PP
Lid: PE
Inner jar: PP
Outer jar: SAN
N4 343
Capacity : 300 ml
Type : Cream Jar
Material
Outer Cap : ABS / PS
Inner Jar :PP
Outer Jar : ABS / PS
N4 262-1
Capacity : 50 ml
Type : Cream Jar
Material
Cap : ABS / SAN
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 060-2
Capacity : 35 ml
Type : Dispenser
Material
Overcap : SAN
Actuator : PP
Shoulder : ABS
Inner Bottle : PETG
Outer Bottle : SAN
N4 060-1
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : SAN
Inner cap : PP
Lid : PP
Inner jar : PP
Outer jar : SAN
N4 059-3
Capacity : 130 ml
Type : Dispenser
Material
Cap : SAN
Actuator: PP
Shoulder : ABS
Inner Bottle : PET
Outer Bottle : SAN
N4 059-1
Capacity : 50 ml
Type : Cream Jar
Material
Outer cap : SAN
Inner cap : PP
Lid : PP
Inner jar : PP
Outer jar : SAN
N4 023-1
Capacity : 30 ml
Type : Cream Jar
Material
Plaque : SAN
Cap : SAN/ASA/ABS
Lid : LDPE
Inner Jar : PP
Outer Jar : SAN
N4 024-1
Capacity : 50 ml
Type : Cream Jar
Material
Plaque : SAN
Cap : SAN/ASA/ABS
Lid : LDPE
Inner Jar : PP
Outer Jar : SAN
N3 545-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP
Bottle : HDPE
Download
Catalog