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 180, 20
Cosmetic packaging
Product
N6 197-1
Capacity : 60 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH
N6 008-1S
Capacity : 8 ml
Type : Tottle
Material
Cap : PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 008-2
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 008-3
Capacity : 70 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 008-6
Capacity : 110 ml
Type : Tottle
Material
Cap : ANS/PP
Reducer : LDPE
Body : LDPE+EVOH
N6 013
Capacity : 15 ml
Type : Tottle
Material
Cap : PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 013-3
Capacity : 25 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 013-1
Capacity : 35 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 013-2
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 019-2
Capacity : 10 ml
Type : Tottle
Material
Cap : PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 014-1
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 014-2
Capacity : 80 ml
Type : 3
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 014-3
Capacity : 120 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 200-2
Capacity : 20 ml
Type : Stick
Material
Cap : PET
Body : PP
Dial : PP
N6 200-3S
Capacity : 15 ml
Type : Stick
Material
Cap : PET
Body : PP
Dial : PP
N6 200-3
Capacity : 20 ml
Type : Stick
Material
Cap : PET
Body : PP
Dial : PP
N6 201
Capacity : 35 ml
Type : Tottle
Material
Cap : PP (PCR Available)
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 201-1
Capacity : 50 ml
Type : Tottle
Material
Cap : PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 002P
Capacity : 30 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
N6 004P
Capacity : 70 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
Download
Catalog