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 160, 20
Cosmetic packaging
Product
N4 330N
Capacity : 50 ml
Type : Cream Jar (Grinding Type)
Material
Cap : PETG
Dial : PP
Shoulder : PETG
Inner Jar : PP
Outer Jar : PETG
N4 118-3B
Capacity : 10 ml
Type : Cream Jar
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 592
Capacity : 4 ml
Type : Cream Jar
Material
Cap : ABS
Jar : PETG
N4 594
Capacity : 4.5 ml
Type : Cream Jar
Material
Cap : ABS
Jar : PETG
N4 007A
Capacity : 10 ml
Type : Cream Jar
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 118-3BQ
Capacity : 10 ml
Type : Cream Jar
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 118-2Q
Capacity : 10 ml
Type : Cream Jar
Material
Cap : ABS
Lid : PE
Inner Jar : PP
Outer Jar : SAN
N4 593
Capacity : 5 ml
Type : Cream Jar
Material
Cap : ABS
Jar : SAN
N5 371
Capacity : 4 ml
Type : Lip Stick
Material
Cap : ABS
Shell : AL
Body : ABS
N5 281-1
Capacity : 7.5 ml
Type : Lip Gloss
Material
Cap : ABS/PP
Rod : PETG
Wiper : LDPE
Bottle : PETG
N5 375
Capacity : 7 ml
Type : 1
Material
Cap : ABS
Rod : PETG
Wiper : LDPE
Bottle : PETG
N5 375-1
Capacity : 7 ml
Type : Lip Gloss
Material
Cap : ABS
Rod : PETG
Wiper : LDPE
Bottle : PETG
N5 327
Capacity : 6 ml
Type : Lip Gloss
Material
Cap : ABS
Rod : PETG
Wiper : LDPE
Bottle : ABS+PETG (Double Injection)
N5 328
Capacity : 5 ml
Type : Lip Gloss
Material
Cap : ABS
Rod : PETG
Wiper : LDPE
Bottle : ABS+PETG (Double Injection)
N4 517-2H
Capacity : 25 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N4 517-1H
Capacity : 20 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N4 517H
Capacity : 10 ml
Type : Powder Jar
Material
Cap : ABS
Middle Cap : PP
Mesh : Nylon
Jar : SAN
N6 197S
Capacity : 10 ml
Type : Tottle
Material
Cap : PP
Reducer : LDPE
Body : LDPE+EVOH
N6 197
Capacity : 30 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH
N6 197-3
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH
Download
Catalog