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 40, 20
Cosmetic packaging
Product
N3 629-1
Capacity : 50 ml
Type : Airless
Material
Cap : PETG
Pump : PP/AL.
Bottle : PETG
Base : ABS
N3 629
Capacity : 30 ml
Type : Airless
Material
Cap : PETG
Pump : PP/AL.
Bottle : PETG
Base : ABS
N3 469
Capacity : 30 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 272N
Capacity : 15 ml
Type : Airless
Material
Cap : PP
Pump : PP
Bottle : PP
N3 273-1
Capacity : 30 ml
Type : Airless
Material
Pump : PP
Bottle : PP
N3 272-1
Capacity : 15 ml
Type : Airless
Material
Pump : PP
Bottle : PP
N6 207
Capacity : 25 ml
Type : Tottle
Material
Cap : PP
Reducer : LLDPE
Body : PE+EVOH
N1 169-1
Capacity : 8 ml
Type : Powder Jar
Material
Cover : ABS
Lid : LDPE
Base : ABS
N5 171-1
Capacity : 5 ml
Type : Lip & Eye
Material
Upper cap : ABS
Screw cap : ABS
Jar : SAN / PS
N5 171
Capacity : 3 ml
Type : Lip & Eye
Material
Upper cap : ABS
Screw cap : ABS
Jar : SAN / PS
N4 583
Capacity : 10 ml
Type : Cream Jar (5g+5g Dual)
Material
Jar : PETG
Ring : ABS
N4 510
Capacity : 20 ml
Type : Powder Jar (Ball blusher)
Material
Cover : ABS
Case : PMMA
N3 545-1
Capacity : 50 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP
Bottle : HDPE
N3 545
Capacity : 30 ml
Type : Dispenser
Material
Cap : PETG
Pump : PP
Bottle : HDPE
N2 145
Capacity : 9 ml
Type : Pallet
Material
Cover : ABS
Button : ABS
Insert: EVA
Case : ABS
N2 142-1
Capacity : 6 ml
Type : Pallet
Material
Cover : ABS
Insert: ABS
Case : ABS
N2 142
Capacity : 20 ml
Type : Pallet
Material
Cover : ABS
Insert: ABS
Case : ABS
N2 141
Capacity : 6 ml
Type : Pallet
Material
Cover : ABS
Insert : EVA
Button : ABS
Case : ABS
N2 138-4
Capacity : 8 ml
Type : Pallet
Material
Cover : ABS (Magnet)
Insert : ABS
Case : ABS
N2 138-3
Capacity : 4 ml
Type : Pallet
Material
Cover : ABS (Magnet)
Insert : ABS
Case : ABS
Download
Catalog