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("20210928s7jqc7if8c") and product.viewYn in (1,3) ORDER BY registdate desc LIMIT 200, 20
Cosmetic packaging
Product
N6 287
Capacity : 40 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH
N6 287-1
Capacity : 60 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH
N6 269-1
Capacity : 50 ml
Type : Tottle
Material
Cap : PP (PCR Available)
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 269
Capacity : 35 ml
Type : Tottle
Material
Cap : PP (PCR Available)
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 269-1M
Capacity : 50 ml
Type : Tottle
Material
Cap : PP (PCR Available)
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 231-1
Capacity : 15 ml
Type : Stick
Material
Cap : PP
Body : PP
Dial : PP
N6 231-1R
Capacity : 15 ml
Type : Stick
Material
Cap : PP
Body : PP
Dial : PP
N6 231
Capacity : 20 ml
Type : Stick
Material
Cap : PP
Body : PP
Dial : PP
N3 570
Capacity : 5 ml
Type : Airless (Refillable)
Material
Cap : PETG
Inner Bottle : PP
Outer Bottle : PETG
N3 570-1
Capacity : 10 ml
Type : Airless (Refillable)
Material
Cap : PETG
Inner Bottle : PP
Outer Bottle : PETG
N1 239A
Capacity : 12 ml
Type : Compact
Material
Outer Case : ABS
Inner Case : PP
N1 239B
Capacity : 12 ml
Type : Compact
Material
Outer Case : ABS
Inner Case : PP
N4 118-4
Capacity : 8 ml
Type : Cream Jar
Material
Cap : ABS
Jar : SAN
N6 237 (RST)
Capacity : 50 ml
Type : Tube
Material
Cap : PP
Roller : SUS316
Shoulder : PP
Button : POM
Tube : LDPE+EVOH
N6 237E
Capacity : 50 ml
Type : Tube
Material
Cap : PP
Roller : TPE
Shoulder : PP
Side Button : POM
Tube : LDPE+EVOH
N6 237S
Capacity : 50 ml
Type : Tube
Material
Cap : PP
Spatula : TPE
Shoulder : PP
Side Button : POM
Tube : LDPE+EVOH
N4 511
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Jar : SAN
N4 007P
Capacity : 2 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : PE
Jar : SAN
N4 316P
Capacity : 5 ml
Type : Powder Jar
Material
Cap : ABS
Sifter : PE
Jar : SAN
N4 001
Capacity : 2 ml
Type : 99
Material
Cap : ABS
Sifter : PE
Bottle : SAN
Download
Catalog