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 140, 20
Cosmetic packaging
Product
N3 009S
Capacity : 30 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 006S
Capacity : 15 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 009SD
Capacity : 30 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : HIPS
N3 012S
Capacity : 45 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 013S
Capacity : 50 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : ABS
N3 013SD
Capacity : 50 ml
Type : Airless
Material
Cap : PETG/ABS
Actuator : PP/AL
Shoulder : ABS
Bottle : SAN/PETG
Base : HIPS
N6 277-2
Capacity : 7.5 ml
Type : Stick
Material
Cap : PETG
Body : PETG
Dial : PETG
N5 374
Capacity : 4 ml
Type : Lip Gloss
Material
Cap : PETG
Wiper : PE
Bottle : PCTG
N2 159
Capacity : 10 ml
Type : Pallet
Material
Case : PETG
Inner Case : PETG
Dish : AL
N1 271
Capacity : 15 ml
Type : Compact
Material
Outer Case : PETG
Button : PETG
Frame : PE
Inner Case : PET
N1 229
Capacity : 15 ml
Type : Compact
Material
Outer Case : ABS
Inner cover : PP
Inner Case : PE
Mid-Ring : PP
N3 546 (DAC)
Capacity : 15 ml
Type : Compact (Airless)
Material
Outer Case : ABS
Button : PCTA
Plate : POK
Inner Case : PP
Piston : HDPE
Base : PP
N3 586 (FNA)
Capacity : 15 ml
Type : Airless
Material
Cap : PETG
Applicator : PP
Button : ABS
Shoulder : PP
Bottle : PETG
Base : ABS
N5 361-2
Capacity : 5 ml
Type : Click Pen
Material
Cap : PP
Head : PP+SPONGE
Body : PP
Piston : PE
N5 360-1
Capacity : 2.5 ml
Type : 2
Material
Cap : PP
Head : PP+Brush
Body : PP
Piston : PE
N5 364-1
Capacity : 4 ml
Type : Click Pen
Material
Cap : PP
Head : PP+Brush
Body : PP
Piston : PE
N5 361
Capacity : 1.5 ml
Type : Click Pen
Material
Cap : PP
Head : PP+SPONGE
Body : PP
Piston : PE
N5 361-1
Capacity : 2.5 ml
Type : Click Pen
Material
Cap : PP
Head : PP+SPONGE
Body : PP
Piston : PE
N5 361-3
Capacity : 7 ml
Type : Click Pen
Material
Cap : PP
Head : PP + Sponge
Body : PP
Piston : PE
N6 014
Capacity : 30 ml
Type : Tottle
Material
Cap : ABS/PP
Reducer : LDPE
Body : LDPE+EVOH (PCR Available)
Download
Catalog