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 100, 20
Cosmetic packaging
Product
N6 285
Capacity : 30 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 148-3
Capacity : 40 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 148
Capacity : 60 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 148-1
Capacity : 70 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 286
Capacity : 30 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 286-1
Capacity : 40 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 286-2
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 285-1
Capacity : 40 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 285-2
Capacity : 50 ml
Type : Tottle
Material
Cap : ABS+PP
Reducer : LDPE
Body : PE+EVOH
N6 143
Capacity : 50 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 143-3
Capacity : 30 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 143S
Capacity : 50 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 143-1
Capacity : 60 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N6 143-2
Capacity : 70 ml
Type : Tottle
Material
Cap : PETG+PP
Reducer : LDPE
Body : PE+EVOH
N5 154
Capacity : 4 ml
Type : Lip Stick
Material
Cap : PCTG
Shell : PCTG
Cup : PCTG
Base : PCTG
N6 252-2
Capacity : 3 ml
Type : Stick (Air-Tight)
Material
Cap : ABS
Shell : AL
Shoulder : PP+TPE
Body : ABS
N6 273-1
Capacity : 10 ml
Type : Stick (Air-Tight)
Material
Cap : PP
Shell : PP
Body : PP
N6 252-1
Capacity : 22 ml
Type : Stick (Air-Tight)
Material
Cap : ABS
Inner Cap : PE
Shoulder : PP+TPE
Cup : POM
Body : ABS
N6 252
Capacity : 10 ml
Type : Stick (Air-Tight)
Material
Cap : ABS
Shell : AL
Shoulder : PP+TPE
Body : ABS
N3 523H
Capacity : 30 ml
Type : Airless
Material
Cap : ABS
Actuator : PP
Shoulder : PP/PETG
Jar : SAN/PETG
Download
Catalog